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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-06-08 : 05:18:03
|
| Hi guyscould any one tell me the various parameters that affect theperformance of the server.Becasue, in my organization, we r facing a drastic change in theserver performance which has been good till 10 days back.This server has been used for running Test scriptsThanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-08 : 05:49:12
|
| Disk, processor, bus, memory, ....But the most important factor and usually the problem is what is being run i.e. for sql server the way the sql is written.I would look at that first.Could just mean that you have more data and have hit a threshhold - maybe need more indexes or to rebuild them or update statistics.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-06-08 : 06:00:36
|
| "we r facing a drastic change in the server performance which has been good till 10 days back"How long was it running OK before that - long time, or short time?What's changed? Lots more data added? More databases? Other applications? Network changes? (Maybe NIC has fallen back from 100Mb Full Duplex to Half Duplex, or even 10Mb!)Has a drive failed in the RAID and not been detected?Are you running Database Administration Housekeeping? (Index rebuilds / defrag / update statistics / recompile SProcs) Is it possible that you were running those but the job has stopped?If you haven't already done it I would stop/start SQL Server if that's easy - that will throw away the cache and start over. if the cached queries are hopeless wrong for the current data that should make a different.(If the server is not 24/7 consider defragging the files whilst SQL is stopped)Check the Event Log too in case there are any hardware issues reported.Just in case its hardware do aDBCC CHECKDBto see if there is damage to the database.If you don't have an up-to-date backup best to do one of those before trying any of this stuff!Kristen |
|
|
|
|
|
|
Urgent Pls:Low server performance