IT Employment
I have a M$ SQL server that needs to be restarted regularly, at least once a week, is this normal? If the restart is not done, the preformance degrades to nil. My question isn't so much "how often" (as often as needed of course!) but how often does everyone else need to?
-DJW
by mauri_1848
I have one SQL2000 Server installed on a Dell PowerEdge Server with SCSI hard drives. Since september 2001, I shutt down the server just 5 times for cleaning and maintenance, but I NEVER needed restar the SQL Server.
Of course, the server has no internet connection, full patched and a serveral maintenance plan.
Do you have autoshrink enabled? how large is your log file? Which kind of systems use the DB?
by dwiebles
by mauri_1848
Answer this questions and I'll send you a list of recomendations.
- How the clients connects to the server? it is ODBC?
- How much is the average of simultaneous connected users?
- Is your SQL Server replicated?
- How large is your log file?
- Do you have a scheduled maintenance plan? how often it executes?
- which kind of authentication do you use?
by dwiebles
-yes clients connect w/ odbc,
-The average simultaneous users is 45-50 range, though the 3 CRM load balancing servers interact with the DB, not the end user.
-the log files are
-CRM DB is 202805312 KB.
-other 4 active are 517184 KB, 768 KB, 39296 KB and 102144 KB.
-replication is not occuring.
-schedualed maintenace on servers is daily backups, with the exception of the CRM Db which optimization, integrity check, trans log backup daily and DB info backed up every 2 hours.
-SQL and windows authentication, No audit.
Thanks alot, any suggestions are appreciated.
-DJW
This discussion is closed to new replies.
Sort by Trending