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 |
|
SandyRyan
Starting Member
5 Posts |
 Posted - 2004-11-06 : 09:07:24
|
| i'm at a lost. I hae a sql server system which holds 15 databases.. a couple of days ago this database starting deteriating in performance - and once i rebooted it started behaving again.Looking at the SQL Logs - I noticed that one of the databases keeps starting. Every 15-30 seconds... thus its having problems.. as the machine it was affecting was critical - I took this database and put it on a test box... its still 'starting' but now about every 45 seconds....What would cause this? How do I fix it - as it causes serious performance problems.....thanksSandy |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-06 : 09:12:23
|
| I think you mean it is auto-opening and auto-closing? Check to see if either of these settings is turned on, and turn them off if they are. You can find them in Enterprise Manager by right-clicking the database, Properties, Options tab. You can also use the sp_dboption procedure in Query Analyzer. Books Online has more details about sp_dboption. |
 |
|
|
SandyRyan
Starting Member
5 Posts |
Posted - 2004-11-06 : 09:17:28
|
| Thanks -- i just turned off auto close! |
|
|
|
|
|
|
database keeps starting