So I will just walk through the wizard here. So behind the screen here you will see in my list of custom counters. Now I have already added this script as a custom counter. And then I can go over and plug that right into a script spot here on the SQL script custom counter. So I have the script here that is measuring the uptime of tempdb basically. So single numeric value keeps the reliability around that particular feature. ![]() And that is because we need to be able to assign a threshold to whatever a custom script we add. As a matter of fact, when we go to Administration and add the custom counter that is one of the things that pops up here is that it must return a single numeric value. And that is that it must return a single numeric value. So the thing is with SQL Diagnostic Manager if you plan to add a SQL script as a custom counter there is a caveat to using that feature. When you execute, it displays the number of minutes that tempdb has been online. This is basically running a select date diff against certain the service runtime for tempdb. First, we are going to going to jump over here to Management Studio where I have the script laid out. ![]() Today I am going to show you how to add a custom SQL script to measure SQL Server uptime. Welcome to IDERA virtual education for SQL Diagnostic Manager.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |