Why my SQL Server is so slow?
-
I just installed SQL Server on my machine, and found that it was really slow! I even had to wait for quite a while when create a table or open an empty table in the Enterrpise Manager. Accessing it from a program is also painfully slow. I got SQL Server SP2 installed as well, but didn't solve the problem. Any ideas? Thanks a lot! Wenrich
-
I just installed SQL Server on my machine, and found that it was really slow! I even had to wait for quite a while when create a table or open an empty table in the Enterrpise Manager. Accessing it from a program is also painfully slow. I got SQL Server SP2 installed as well, but didn't solve the problem. Any ideas? Thanks a lot! Wenrich
What machine/spec are you running it on? Memory, OS, Clock-Speed, Harddisk ( fragmentation) all plays a part on the overall speed. Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark Twain -
What machine/spec are you running it on? Memory, OS, Clock-Speed, Harddisk ( fragmentation) all plays a part on the overall speed. Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning Mark Twain
Get your facts first, and then you can distort them as much as you please Mark TwainThats quite true what you are saying. I did a small test the other day. First test I set SQl to use all memoty available (384mb in my case). The avg time for an INSERT plus several updates x 100 were 30ms. The 2nd test I dropped SQL's memory to 128mb. The same test yeilded results of 65ms per "operation". It seems SQL likes memory (like most MS products). In a production enviroment I would bother if the SQL server didnt have at least 512mb RAM. :) WebBoxes - Yet another collapsable control, but it relies on a "graphics server" for dynamic pretty rounded corners, cool arrows and unlimited font support.
-
I just installed SQL Server on my machine, and found that it was really slow! I even had to wait for quite a while when create a table or open an empty table in the Enterrpise Manager. Accessing it from a program is also painfully slow. I got SQL Server SP2 installed as well, but didn't solve the problem. Any ideas? Thanks a lot! Wenrich
You can try to reinstall.:)