January 26, 2012 at 4:12 am
We have SQL Server 2000 Ent edition, along with SQL 2000 Analysis services running on Windows 2003 R2 Ent edition. 16GB memory is available on the box. Since SQL 2000 AS doesnt support PAE, we have enabled /3GB switch. When we run a query against a database, it is taking over 26 sec. I have set statistics IO to see why it is taking. Physical reads 0, read-ahead reads 0, scan count 1, logical reads 58.
We have similar environment with 3.5GB memory and same database is available on this box. When the same query is executed, it took only 3 sec. statistics IO details are same as above on this server.
Both tables statistics is updated on same date/time and row count is same.
Any guesses on further troubleshooting please?
January 26, 2012 at 8:21 am
What else is happening on each box? It sounds like there would be a lot more happening on the original server which means SQL Server may not have the same resources as on the second server.
Thought of something else. What are the execution plans? Perhaps one is getting a parallel plan and one is not. Parallel doesn't always mean faster either.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 26, 2012 at 10:51 am
are the index fragmentation levels the same on both databases?
have you checked to see if there is any blocking?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply