Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Automating SQL Server Health Check (SQL Server 2005) Expand / Collapse
Author
Message
Posted Thursday, January 28, 2010 1:45 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234
for CPU, you can create alert in performance monitor
Post #854982
Posted Thursday, January 28, 2010 2:11 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
Fantastic article Ritesh, You are a star DBA............
Post #854997
Posted Thursday, January 28, 2010 2:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234
Thanks Satnam
Post #854998
Posted Thursday, January 28, 2010 2:17 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234
Satnam did you implement this soln?
Post #855001
Posted Thursday, January 28, 2010 2:20 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
Yes Ritesh, i implemented it,it was fantastic.I loved the idea and the entire presentation which i believe only a good DBA can do...........................
Post #855004
Posted Thursday, January 28, 2010 2:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 29, 2014 5:47 AM
Points: 330, Visits: 342
First off - great article and a really handy stored procedure..

When i executed the sp i got this error message

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72
An INSERT EXEC statement cannot be nested.
Msg 242, Level 16, State 3, Procedure uspEmailSQLServerHealth, Line 126
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

It did send me an email though so all's good.
Post #855016
Posted Thursday, January 28, 2010 2:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 18, 2013 2:50 AM
Points: 1, Visits: 24
Hi

Just a suggestion why dont you use table variables instead of temp tables, might reduce the code and the initial checks.

Post #855018
Posted Thursday, January 28, 2010 2:56 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 12:22 AM
Points: 153, Visits: 448
Dale Turley (1/28/2010)
First off - great article and a really handy stored procedure..

When i executed the sp i got this error message

Msg 8164, Level 16, State 1, Procedure sp_get_composite_job_info, Line 72
An INSERT EXEC statement cannot be nested.
Msg 242, Level 16, State 3, Procedure uspEmailSQLServerHealth, Line 126
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

It did send me an email though so all's good.


First off, great article. Thank you for sharing.

However I have encoutered the same issue as above and not yet resolved. (SQL 2005 standard edition)

Also quick correction on your example, just incase anyone doesnt click that

exec EmailSQLServerHealth '10.10.10.10', 'MYProject', 'myself@mycompany.com', 'TestMailProfile', 'My Self'


should be

exec uspEmailSQLServerHealth '10.10.10.10', 'MYProject', 'myself@mycompany.com', 'TestMailProfile', 'My Self'

Thanks again ;)
Post #855021
Posted Thursday, January 28, 2010 2:58 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, August 24, 2014 11:58 PM
Points: 488, Visits: 1,338
@Ritesh,

That's not smthng i was looking at as it goes away from sql..and involves lot of manual configuring alert on each server. Also, when one monitors lot of servers, you would like to store these info at a consolidated single server along with other parameters.

Also, if we can have CPU monitoring we can have it as a part of a quick health check script as well

What I was looking was smthng like xp_fixeddrives. But anyways AFAIK, none of the extended sps do that.. Does anyone have a better solution?



Regards,
Raj

Strictlysql.blogspot.com
Post #855022
Posted Thursday, January 28, 2010 3:16 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 18, 2012 1:22 AM
Points: 325, Visits: 234
thx for correction mark..
Post #855028
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse