Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-16 : 08:10:33
|
| Rakesh Aggarwal writes "Sirwe are running Windows 2003 Server with 15 Win XP Professional; clients and using large database of around 15 GB in MS Sql Server 2000 (Service Pack 4). We are facing problem of the slow response from SQL server while processing a report for the print. The problem is very much and takes time even 30-60 minutes for report generating and for queries it took 2-3 minutes. Kindly give the soln please.thanking youMOhan RakeshNAHAN" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-16 : 08:24:48
|
| What is the task manager, the windows performance monitor and profiler telling you? Have you checked for blocking?Can you post the code for your 30 minute (good gravey) query? How about some data definition language and be sure to tell us where your indices are? What's your hardware like?Have you looked at your query execution plan? Table and index scans?====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
Slow Response from SQL Server