SQL Server Performance Forum – Threads Archive

Assigning maintainence plan

What are the benchmarks which should be kept into considerations while making or assigning a maintainence plan for databases.
I m using the following
Size
Traffic it recive
Fragmentation
Can you suggest more..?
I am wondering will assigning maintainence plan degrade the performance of application.

Creating a maintenance plan is simple if you use the Database Maintenance Plan Wizard that comes with Microsoft SQL Server. In a few minutes, you can set up a general maintenance plan for your important databases. Unfortunately, the wizard can’t help you create a maintenance plan that installs a database. Check the linkshttp://www.sql-server-performance.com/ak_inside_sql_server_maintenance_plans.asp andhttp://www.sql-server-performance.com/tp_centralized_sql_server_monitoring.asp for further information on MP. 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.

Is there any tool exist which can give me the total traffic on a database.
I want to know how much traffic each db is reciving daily and which data base is reciving maximum traffic.

Please check your other post abotu DB Traffic. 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.

]]>