Search Results | SQL Server Performance Forums

Thread by: linus516, Nov 7, 2007, 6 replies, in forum: SQL Server 2005 Performance Tuning for Hardware

hi i find that my Server with SQL Server 2000 always has very high Average Disk Queue Length..............it is over 50 and sometimes over 100. So...

Thread by: linus516, Aug 15, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

as subject many thanks, Linus

Thread by: linus516, Jul 25, 2007, 7 replies, in forum: Performance Tuning for DBAs

Hi all, I face a problem as below: our SQL Server daily has a job to delete 2M records in a table of 13M records. It takes quite long time to do...

Thread by: linus516, Jul 24, 2007, 1 replies, in forum: SQL Server DTS-Related Questions

Hi, I have a problem as below: everyday, our SQL Server need to download about 2M records from a Oracle Server. Therefore, I have built a DTS to...

Thread by: linus516, Jul 24, 2007, 2 replies, in forum: SQL Server 2005 Integration Services

Error when executing the SSIS in Visual Studio 2005 The AcquireConnection method call to the connection manager "EDR_Prod" failed with error code...

Thread by: linus516, Jul 19, 2007, 2 replies, in forum: SQL Server 2005 Integration Services

What is the different between -A table or view. -A table or view using fast-load options. for OLE DB destination

Thread by: linus516, Jul 19, 2007, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hi, I have a table in Oracle 8 and a table in SQL Server 2005 with the same schema. I have created a SSIS to pull data (2 million rows) from the...

Thread by: linus516, Jul 18, 2007, 3 replies, in forum: SQL Server 2005 Integration Services

Hi All, I encounter the following problem : I create a SSIS in VS2005, it can run successfully in there. then i save the package into Server, and...

Thread by: linus516, Apr 13, 2007, 25 replies, in forum: General DBA Questions

Hi, I am facing a great problem. I have a DB about 80GB. There are 217489811 number of records which include 2005, 2006 and 2007 data in 1 table....