SQL Server Performance Forum – Threads Archive
Sql Server Maintenance
Hello, Does anyone have an estimate as to how long it would take to maintain 125 sql server databases on a weekly basis?thanks!
You have to give more information about all.
1) Hardware (CPU, Disk, RAID, RAM)
2) How big are Databases?
3) What kind of maintenance plan do you want to run? (Integrity, Defrag, Update statistics, etc). Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
Hello, All 125 databases will total about 400 GB. The maintenance plan will include
Integrity, Defrag, Update statistics,Monitor server performance, tweaking performance parameters as necessary to improve response time.Manage logins and server roles. Audit server, database, and object permissions to ensure that only authorized users have access.
Review alert, job, and operator configurations
Compressing data files by removing empty database pages
Monitor Error Logs
Monitor available disk space
Test your backup strategy
Monitor record count, etc…. thanks for any info!!
quote:Originally posted by LuisMartin
You have to give more information about all.
1) Hardware (CPU, Disk, RAID, RAM)
2) How big are Databases?
3) What kind of maintenance plan do you want to run? (Integrity, Defrag, Update statistics, etc). Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
1) Hardware (CPU, Disk, RAID, RAM)
2) How big are Databases?
3) What kind of maintenance plan do you want to run? (Integrity, Defrag, Update statistics, etc). Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
http://www.sql-server-performance.com/rd_osql.asp for your information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Those databases are in one Box or, as Satya think, are in multiple boxes? Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS†with no warranties for accuracy.
Whatsoever that link helps a lot to manage multiple databases, i feel so. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>