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 |
|
ramprasad
Starting Member
2 Posts |
 Posted - 2009-12-06 : 03:41:06
|
| Hello everyone,i am very new to SQL server,Now, i am maintaning 3 SQL servers,How to check whether Database is perfect or not,Daily what i need to ckeck itJust i am checking sql server logs & backup plan & spaces at disk level...other than this what i need to check....please help me any one....all are databases are in simple recovery mode.2 servers are 2005 enterprise edition1 server 2005 express edition1 server is 2008 enterpriseRamprasad |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-06 : 12:22:48
|
| I continuously monitor CPU, RAM, I/O utilization.Periodically check index fragmentation and usage statistics. Rebuild indexes as required.Periodically run DBCC CHECKDB against all databases.Periodically restore backups to testing environment to ensure backups are good. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-06 : 12:27:52
|
quote:
Originally posted by rajdaksha
For what purpose you have these three diff versions installed.
This is not at all uncommon. You purchase the version you need. No point in paying for EE when SE will accomplish your task. Our environment is a mix of SQL 2008 EE, SQL 2008 SE, SQL 2005 EE, SQL 2005 SE. And we still have one last SQL 2000 EE box hanging around. Additionally we have a mix of x32 and x64 systems. |
|
|
|
|
|
|
How to check