.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

2008 Vs 2000 insert running slower

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
While running a insert into a table statement the "new server" is running about 2 seconds slower per every 100,000 records.  This is running the exact same statement, one running Win Server 2000 and SQL Server 2000 and the newer Win Server 2008 and SQL Server 2008 and obviously a newer server for the 2008 stuff, by about 5 - 7 years.  Apparently any write operation is 33% slower.  Has anyone else seen this.  I'm working on getting one of the statements our senior guy is complaining about as I don't know which one he is exactally talking about.  Read times on the new server seem to be faster though so this seems to be just during writing to a table.  This is also in the Managment studio and not in any other software.

View Complete Post

More Related Resource Links

How to get information about Sharepoint Running Workflow in Visual Studio 2008

Can any one tell me about. How i can get information about sharepoint running workflow in visual studio 2008.

Issues with SSIS and SQL 2008 - Integration services not running

Hey guys, I installed SQL 2008 with complete BI studio including Integration Services. When i check in my services - i cant see my integraiton services in there When i try to connect to Integration Service using localhost, I cant connect it And when i try to run setup of SQL 2008 - It shows that Integration Services already installed and that what i checked when i fetched my Installation tool report from SQL Server to verify i have it installed. Why can i access Integration services, if i already have it, Please suggest with ideas, checks i can make to ensure every setting is in place. Thanks. Would appreciate for quick response.  

Oracle Linked serve Query performance in 2000 vs 2008 R2 64 Bit

Hi everyone We have started to migrate one of our reporting systems from Sql 2000 to Sql 2008 R2.  One of the steps has been to test the perforance of certain Oracle linked server queries between each server.  We are finding on average 3 fold better perforance stats (in terms of query completion time) on the old server.  This should obviously not be the case.  The new server has signifantly more CPU/Memory/IO resources to play with, and it is 64 bit (not to mention its new!).  Here's what I got so far: Old server: SQL 2000 on W2000 both fully patched.  Old Dell Dual core with 3 GB of Ram running on two soft IDE Mirrored drives (yes I know... it sucks).  It connecting via the MS OLE DB provider for Oracle (9i client) New server: ESX VMware Server with 2 CPU's assigned, 8 GB of ram connected to large HP SAN.  CPU, ram and IO's have all been ruled out as the problem.  We've tried varying network cards with different results so we havent ruled that out yet.  Its connecting via the Oracle provider for OLE DB (11G 64 bit client) The linked server is an Oracle 9i fully patched server.  All three are on the same network backbone. Running a simple select * query on both servers returns the same number of rows (~76 000) .  It takes ~1:20 on the new server and ~0:20 on the old server. In looking at the wait stati

SQL Server 2008 Powershel trying to access SQL Server 2000

Below is a script from my SQL server 2008 PowerShell trying to connect a SQL Server 2000 instance. PS SQLSERVER:\SQL\SS2K8\DEFAULT\databases> cd \ PS SQLSERVER:\> cd sql PS SQLSERVER:\sql> cd MySS2KMachine PS SQLSERVER:\sql\MySS2KMachine> cd default PS SQLSERVER:\sql\MySS2KMachine\default> cd Databases PS SQLSERVER:\sql\MySS2KMachine\default\Databases> dir and I see a list of all databases on the default (SS2K) instance. I also see al instances on the machine: PS SQLSERVER:\sql\MySS2KMachine\default> cd .. PS SQLSERVER:\sql\MySS2KMachine> dir Instance Name ------------- DEFAULT MSSQL2005 As you can see from the above, there is also a SQL Server 2005 instance installed on the MySS2KMachine. Now, if I try the same thing for a Sql Server 2000 instance on another server (Windows 2003 R2 with SP1) with no SQL Server 2005 or higher installed on the machine, I get the error below: PS SQLSERVER:\> cd sql PS SQLSERVER:\sql> cd MyPureSS2KMachine WARNING: Could not obtain SQL Server Service information. An attempt to connect to WMI on 'MyPureSS2KMachine' failed with the following error: SQL Server WMI provider is not available on MyPureSS2KMachine. --> Invalid namespace Set-Location : Cannot find path 'SQLSERVER:\sql\MyPureSS2KMachine' because it does not exist. At line:1 char:3 + cd <<<< MyPureSS2KMachine PS SQLSERVER:\sql> So it see

Why upgrade is required from SQL Server 2000 to SQl Server 2008

Hi all Can some body share with information about "Why upgrade is required from SQL Server 2000 to SQl Server 2008?"   This question was raised by my Boss why upgrade is required.   I stared saying   My: there is no more   support for SQL Server 2000 from Microsoft   Boss: what you will do  as DBA, Why Required Microsoft support   My: 2008 having very good features where 2000 not have...like Compression, resource governing. .Etc..   Boss: do you mean Database backup compression take full backup and compresse it using ZIP   Finally He (Boss) told me that give document proof why I have go for SQL Server 2008 and what down time you required?   Some body help me why really SQLServer 2008 is required and what are benefits   I have a link; please provide your greatest ideas so that I can convince my Boss.   http://www.mssqltips.com/tip.asp?tip=1462   share your greate Ideas please....   Thanks in Advance     SNIVAS

Insert/Update OLE Attachment(Binary datatype) using SQL server 2000

Hi All, In the same senario how we can Insert/Update OLE Attachment(Binary datatype)  from one source table to other destination table by using SQL Server 2000 not with C# fronend code. Appreciated if you can give fix on this regads, Divakar.

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

(SQL Server 2008) Exporting entire databases to SQL CREATE/INSERT statements

Hi All, I'm looking for a way to export SQL Server 2008 (Express or otherwise) databases to CREATE/INSERT statements.  I've seen a million threads (give or take) with instructions for creating large (often illegible) TSQL scripts for the task.  However, I'm hoping that this isn't the only way by which to do it.  I have need to regularly back up the data from existing MS SQL Server DBs (which are used by some of our standard apps) to various other MySQL and PostgreSQL databases (which are used by PHP and Rails web front ends).  I need to export them from MS SQL Server 2008 to a general format (i.e. INSERT statements) and perform regex edits on the file as necessary. FYI, I've written a few applications that connect to the various DBs over ODBC, etc. and transfer the data row by row.  You can image how painful this process is... I realize that there are many tools that do this.  However, most of them approach the issue from the standpoint of migration, and not that of regularly scheduled backups.  Also, this tool will need to eventually be distributed so having to purchase a license for the migration app for each person/group simply isn't feasible. Anyway, if you guys have a quality, straightforward solution to this issue, it would certainly be appreciated. Best.

ssis sql 2000 image to 2008 varbinary Failed to retrieve long data for column

Hi, I have a task that to migrate the image type column from sql 2000 to varbinary type in sql 2008. The source column having 3812353 max datalength size for the column. The package always failed with following error message. [OLE DB Source [13177]] Error: Failed to retrieve long data for column "attch_file_content_t". [OLE DB Source [13177]] Error: There was an error with output column "attch_file_content_t" (13209) on output "OLE DB Source Output" (13187). The column status returned was: "DBSTATUS_UNAVAILABLE". [OLE DB Source [13177]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "attch_file_content_t" (13209)" failed because error code 0xC0209071 occurred, and the error row disposition on "output column "attch_file_content_t" (13209)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. Meng Chew

data migrations from sql server 2000 to 2008

Hi,   Can any one please help me by giving some good links / tutorials  for migrating data from sql server 2000 to 2008 using SSIS     Thanks In Advance    Padmaja 

Error restoring SQL 2000 db to SQL 2008 - The WITH MOVE clause can be used to relocate one or more f

Hi, While trying to restore a SQL 2000 db into SQL 2008, I get this error: ------------------------------ Restore failed for Server 'S2B22347'.  (Microsoft.SqlServer.SmoExtended) ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: File 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db.mdf' is claimed by 'CCHRI_UAT_Tran'(3) and 'CCHRI_UAT_Data'(1). The WITH MOVE clause can be used to relocate one or more files. (Microsoft.SqlServer.Smo) ------------------------------ The script looks something like this: RESTORE   DATABASE [Build51_Testing_db] FROM DISK = N'C:\Shival\Build51_Testing_db_bkp' WITH FILE = 1, MOVE N'CCHRI_UAT_Data' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db.mdf', MOVE N'CCHRI_UAT_Tran' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db.mdf', MOVE N'CCHRI_UAT_Index' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db.mdf', MOVE N'CCHRI_UAT_Log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db.LDF', MOVE N'CCHRI_UAT_Log1' TO N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Build51_Testing_db.LDF', NOUNLOAD, REPLACE, STATS = 10 GO Please help me resolve this. Shival

is SQL 2000 32 bit supported on Windows 2008 R2 64bit?

Question as stated. Could anyone provide an official source from MS, wether is supported or not supported. Really appreciate it.

SQL server management studio 2008 freezes when running a query to Grid result

Hello, I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx 6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess. Suggestions anybody? Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.3798.0 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 4.0 5.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4952 Operating System      6.0.6001 regards, Pim

update sql 2008 with rows in sql 2000

Hi All, Currently I have data being inserted / updated on sql 2000. I want to update sql 2008 up to the minute. So I need to check and update sql 2008 with insert / update or delete occurred in sql 2000. My question is how to do it? I do not have timestamp column in any table. So do I need to add timestamp datatype column? If I do, then how do I keep track of starting and end value? Thanks in advance.  

Upgrade SQL Server 2000 to SQL Server 2008 in Cluster--Recomendations

Hi all I have   6 cluster environments and 10 standalone servers and mix  of  32 bit  64 bit. As I know In place Upgrade not possible SQL2k 32 bit to SQL2008 64 bit. What I want to know is……… 1. If I purchase SQL Server 2008 Ent edition that will have both 64 bit and 32 bit edition or I have purchase separately ? 2. How to do side by side upgrade in Cluster environment I mean I can’t ask my company to provide other cluster to do side by side upgrade. If I do installation in same cluster machines, I can’t provide same Instance name for SQL Server 2008 Instance.hance it is very difficulty for application connectivity Please some body provides me best approach to drive in Upgrade from SQL2k to SQL2008. Thanks in Advance      SNIVAS

Restoring a 2008 Database in a 2000 Database.

I've been trying to restore a SQL Server 2008 database in SQL Server 2000 and it seems impossible. Does anyone know how to do it or maybe will be able to point me in the right direction?

SSAS DB migation issue from SQL 2000 to SQL 2008

While  running migration wizard  to migrate sql 2000 Analysys service DB from 2000 to  2008  Validation step  failing with  datatype mismatch.Please assist me here
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend