The set-up is Dell PowerEdge 2950 with two dual-core Xeon CPU, 4GB RAM and plenty of SAS RAID-5 disk storage. The system is running ESX Server v3.5 (for disaster recovery). A single virtual operating system is installed running Windows 2003 R2 standard 64 bit with the latest service packs. The core software...

Hi There I created the test below as a quick check of the servers committed write capability. This scripts runs acceptably fast on my laptop, (which is about 3 year old 7200rpm hard disk, 2.something GHZ pentium processor. 2gb memory. Windows XP 32 bit.) By comparision we have a 64 bit server that is...

I have a webapp in Asp.net 1.1 with SqlServer 2005 Express Edition. It's a typical small website with 1.000 registered users and 100 articles (most textual) published. This thing is on a Pentium 4 single-processor machine with 512mb of RAM which hosts both the SQL and the IIS. The site has only 600...

I have the following view's select statement - I have indexes on all the columns used in the joins and wheres and still - "select *" on this view is taking 2 minutes for getting 3493 rows. I see an "INDEX SPOOL" in the query execution plan. I broke it down to multiple views and...

Dear All, I'm new in this forum, and quiet new also in SqlServer also, so please be gentle! In my program, I use a .mdf database that is about 3Go. This DB contains about 1 million records. My problem is that, in my program, the first access to the database (ie the first request) is slow. On my test...

Hello, my name is Tim and it is my first post on sql-server-performance.com I have a problem with the duration of a sql-query, but I don't know how I can optimize this. Here are the database-tables: Table1 (2.600.000 lines): A_CODE (PS,int, NOT NULL) B_CODE (PS,int, NOT NULL) C_CODE (PS,int, NOT...

Hi, I am using SQL Server 2005 Import wizard/DTS Package to Import one table data from X Server to Y Server. To Import 20 million records its taking almost >3 hours, when i am importing i observerd in Y Server -> Task Manager -> Network Utilization is 0.25% of 1 Gbps. If i am copying any fdata...

Hi Everyone, The following article I read puzzles me regarding the Paging File, http://technet2.microsoft.com/windowsserver/en/library/00284c8d-7a42-40f2-8a01-8de61dccd8c91033.mspx?mfr=true. "... Under such circumstances, the effectiveness of this large of page file could be minimal, based on the...

Introduction: This article helps you to understand the fact that sys.dm_exec_query_stats returns incorrect CPU utilization when a query executes in parallel. The purpose of this article is to help you better understand SQL Server 2005 Performance Monitoring and Tuning. The purpose of this article is...

Hi guys, I want to have a synthetic workload for testing various "performance features" of SQL Server. Here are the requirements of the workload off the top of my head - Scalable. The workload should be able to scale from running on a small desktop level machine (dual core 2 GB RAM with one...