Saving Time with Proactive DBA Monitoring

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sadequl Hussain » Saving Time with Proactive DBA Monitoring

18 posts, Page 1 of 2

1 2 »»

Saving Time with Proactive DBA Monitoring

Rate Topic

Display Mode

Topic Options

Author

Message

Sadequl Hussain-911759

Posted Monday, July 20, 2009 11:32 PM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 9:50 PM
Points: 75, Visits: 126

Comments posted to this topic are about the item Saving Time with Proactive DBA Monitoring

Post #756328

nitin1353

Posted Tuesday, July 21, 2009 1:47 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 11:28 AM
Points: 15, Visits: 97

Hi, Excellent article
I am working in a big environment where we have a Monitoring DB on each instance but i am still confused how do we set that up.
Can you help me in that
Regards

Post #756363

Sadequl Hussain-911759

Posted Tuesday, July 21, 2009 3:24 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 9:50 PM
Points: 75, Visits: 126

nitin1353 (7/21/2009)

Hi, Excellent article
I am working in a big environment where we have a Monitoring DB on each instance but i am still confused how do we set that up.
Can you help me in that
Regards

Hi Grasshopper, thanks for your post. As I mentioned in the article - monitoring can be done either via a central server or from each server individually. Both are valid approaches. Can you be specific about which area you are seeking help about?

Post #756412

nitin1353

Posted Tuesday, July 21, 2009 3:27 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 11:28 AM
Points: 15, Visits: 97

I was talking about the latter one,with Each Monitoring DB on each instance.
Can you help me in setting this up
Regards

Post #756418

Sadequl Hussain-911759

Posted Tuesday, July 21, 2009 5:03 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 21, 2012 9:50 PM
Points: 75, Visits: 126

nitin1353 (7/21/2009)

I was talking about the latter one,with Each Monitoring DB on each instance.
Can you help me in setting this up
Regards

Hi Grasshopper, the techniques I mentiopned in the article can be implemented as stored procedures in a database. The database can be rolled out in each individual instance and configured to send e-mails to a designated DBA.

How you implement the functionality (specifics of the actual monitoring procedures) is subject of further articles, code snippets etc.

Post #756463

nitin1353

Posted Tuesday, July 21, 2009 5:10 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 11:28 AM
Points: 15, Visits: 97

Thanks, please let me know if you can help me in creating the same environment
Regards

Post #756470

Grumpy DBA

Posted Tuesday, July 21, 2009 8:22 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:29 PM
Points: 4,172, Visits: 616

There are plenty of scripts on this web site that can be used to implement database monitoring on your servers. The author gets you started with an outline of what to monitor, you actually need to implement the jobs yourself. Too many people are looking for the "easy" button and want things done for them, you will learn more by doing it yourself.

Post #756621

aqkhan_k

Posted Tuesday, July 21, 2009 8:34 AM

SSC-Addicted

Group: General Forum Members
Last Login: Friday, May 24, 2013 6:12 AM
Points: 462, Visits: 136

Hi Sadequl Hussain

Can you share some of the scripts for stored procedures so that I aslo start work on that

AQ KHAN

Post #756642

DavidP-340734

Posted Tuesday, July 21, 2009 3:36 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 12:25 PM
Points: 165, Visits: 87

At the last three jobs I have had as a DBA I have set up “Dashboards”. The first was an ASP page that connected to each data server and executed code to monitor failed jobs, files and disk sizes and reported on other database statistics. The last two places I have used reporting services. In my current position I have set up a reporting services dashboard that has a color coded list of each production data server’s health. We have approximately 40 production databases spread over 10 servers.

Each server name links to another report the directly runs dynamic queries of the master and msdb tables to report on failed jobs, lists of disk drives and space used, server up time, version info and each database. The databases listed shows logical names, segments, size, space used, and growth type. I also run a monthly job that runs a defrag analysis and chkdsk with output to a text file that I import into a table.

When a job has failed it sends an e-mail to the IT department. The dashboard will list the failed job and links to a “run sheet” that lists: job name, level, contact, re-run instructions, location of scripts, output files, and links to log files. Anyone in the IT department can go to the reporting services report and see the health of the entire production database system and quickly identify anything that might need immediate escalation.

Post #757007

Chris Hamam

Posted Tuesday, July 21, 2009 5:21 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 3:29 PM
Points: 73, Visits: 520

Nice article Sadequl - love your work!
Smile

--Chris Hamam

Life's a beach, then you DIE (Do It Eternally)

Post #757059

« Prev Topic | Next Topic »

18 posts, Page 1 of 2

1 2 »»

Permissions