Maintenance plans OR Tools in Place

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Maintenance plans OR Tools in Place

Author

Topic

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2009-01-28 : 17:09:49

Hi Experts

you are greatly appreciated for many solutions everytime.

I was executing the maintenance plans manually as some of them were

needed to run during the after business hours.

Jobs:

Table Fragmentation

Index Fragmentation

Index Rebuild

Blocking Issues

Performance Audit Checks

May anyone help in either locating these plans to go automated , It

can be possible if included in Maintenance Jobs but in order to

monitor the results OR is there any TOOL that can be administered

against it automatically.

Your help is greatly appreciated.

Thanks in advance

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-28 : 17:34:05

You can schedule in Job created by Maintenance plan to Automate it .or if you have scripts you can put that in Jobs and schedule it whenever you need to.

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2009-01-28 : 21:47:49

Thanks So Deep.

The Question is there any TOOL that can do this particular job apart from aministering through the Maintenance Plans.

Can anyone suggest any such TOOL to comprehend the tasks following.

Table Fragmentation

Index Fragmentation

Index Rebuild

Blocking Issues

Performance Audit Checks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-28 : 23:25:47

Why you need Tools if it can done within boundary of SQL Server?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-29 : 00:19:38

I never use maintenance plans. I write my own scripts to do these things. My scripts actually work much better than the maintenance plans for things like the fragmentation task.

Here they are: http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

And here's how my production environments are setup: http://weblogs.sqlteam.com/tarad/archive/2008/06/30/SQL-Server-jobs-on-production-instances.aspx

I'm currently working on a blocking script.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

pdset
Constraint Violating Yak Guru

310 Posts

Posted - 2009-02-04 : 23:49:41

Thanks Tara for encoding.

However, Our Organisation is interested in Maintenance plans so far I have performed in MP's and did worked out however, they would like to keep them in the form of tools using (3rd Party tools)

Is there any such tools where I can browse them.

Thanks in Advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources