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 |
|
BClingaman
Starting Member
2 Posts |
 Posted - 2007-08-23 : 17:28:23
|
| I have a SQL 2k database, relatively small, < 1Gb, WinXP. Whenever I try to do anything in Ent Man I get the hour glass for minutes every time. Customers are not complaining. Performance Monitor and the db logs have not revealed any bottlenecks so far. Hardware tested good. All other applications run normally. Log file is about 80mb. This has started just recently.I am a rookie so I need a hint on what to check. Indexes? Logging? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 22:21:43
|
| Do you have msde? Disable db option 'auto close' if so. By the way, how often do you rebuild index/update statistics? |
 |
|
|
BClingaman
Starting Member
2 Posts |
Posted - 2007-08-24 : 10:52:00
|
| It's SQL Server 2k Standard, not msde.Rebuild indexes? That sounds like something to examine. I doubt if is being done, at least not manually. Does rebuilding automatically on schedule require a stored procedure? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-24 : 23:06:26
|
| You can do that with maintenance plan or 'dbcc dbreindex'. |
|
|
|
|
|
|
Server admin very slow