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 |
|
indersshekhawat
Starting Member
26 Posts |
 Posted - 2008-07-05 : 08:52:40
|
| Please give me the list of posible reason that why sql server database is going slow. and how i an increase it's performacnce/speed |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-05 : 22:24:01
|
| Not enough memory,High cpu usage,High i/o,Statistics not up to date,Table doesn't have proper index,......... |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-06 : 08:16:12
|
| I think you need to perform some sort of audit , as systematic as possible , find out where the delays are happening . Progress with memory issues first, disk and the CPU. Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-07-07 : 03:20:02
|
| .........bad code????...cursors? |
|
|
|
steel
Posting Yak Master
107 Posts |
Posted - 2008-07-08 : 05:39:25
|
| hi first of all check the tables for indexes because these are the most vital things.secondly check the memory allocated to sql server..resources available at the machine... |
|
|
|
|
|
|
Reason and solution For Performance