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 |
|
veggiop
Starting Member
10 Posts |
 Posted - 2011-04-13 : 05:49:13
|
| I am using window Server 2008 64bit with MS SQL Server 2008 64 bit Service Pack 1 installed. Usually, My DB becomes so slow and respond very poorly. To Solve this problem I restart the SQL Server(MSSQL08) Service. I want permanent solution of this problem.I would be very thankful for prompt response.Thanks |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2011-04-13 : 07:33:52
|
| use Profilera) Locate any locking behaviour and resolveb) Locate any poorly performing queries/procedures and resolvec) Examine memory allocations and see if configuration changes (and/or equipment upgrade) need to be maded) provide more raw/useful information and ask more questions here. |
 |
|
|
|
|
|
Database Response is too slow