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 - 2003-07-08 : 07:16:14
|
| Hitsi writes "I have a 10GB sql server 7 databaseSince last few days, all of a sudden, the performance has degraded like any thing. There are no material changes in the size of the database.The activities which used to take 30 minutes now takes 90 minutes! Can anyone please guide me abt possible causes & how to identify the same?The database is daily maintained by automated plans to reindex & shrink." |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-07-08 : 09:01:58
|
| you can investigate the reasons by using Performance monitor and Sql Profiler.read some articles on http://www.sql-server-performance.com/ on how to use performance monitor .-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2003-07-08 : 10:00:02
|
| Is it slow all of the time now or just during certain hours? There are many things that could cause a slow down. I'd start by looking for something that has changed on the server. Has anything new been installed, hardware or software? Check out the server hardware too... a drive failure in a raid set or the loss of a bank of RAM could cause this kind of slow down. Another thing to look at is your maintanence job schedules. Are your reindex jobs running into your backup jobs? That kind of overlap can really grind things to a halt.Autoshrink is not a setting that should be turned on in a production environment.Jeff Banschbach, MCDBA |
|
|
|
|
|
|
sql server performance degradation