Timeline for Running a SQL Server query with as little impact as possible
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 31, 2015 at 21:11 | history | edited | marc_s | CC BY-SA 3.0 |
added 57 characters in body; edited title
|
| Aug 28, 2015 at 12:28 | comment | added | Reaces | @AaronBertrand Due to certain security constrictions the first line helpdesk is not allowed to access the server remotely. Only SSMS sessions. | |
| Aug 28, 2015 at 12:20 | comment | added | Aaron Bertrand | Wouldn't perfmon or resource monitor or procmon be better ways to capture CPU metrics than the system_health session? | |
| Aug 28, 2015 at 11:15 | history | tweeted | twitter.com/#!/StackDBAs/status/637221993729933312 | ||
| Aug 28, 2015 at 10:33 | comment | added | Reaces | @Colin'tHart I agree. I'm very new at my current job and it's the first thing I want to change. Consistent and comprehensive statistic gathering. But you don't change everything over night, and I want first to get them using a template to respond to queries about the statistics, some of the responses I've seen through our mailbox have been lackluster. | |
| Aug 28, 2015 at 10:15 | comment | added | Colin 't Hart | Seems to me your current monitoring system is inadequate if it doesn't have such basic metrics readily available. | |
| Aug 28, 2015 at 9:42 | answer | added | David Spillett | timeline score: 2 | |
| Aug 28, 2015 at 9:40 | comment | added | Reaces | @Shanky I added an example. The purpose behind it is to allow our helpdesk to give consistent answers to questions coming from other departments. The question often arises to check cpu usage or memory usage on our instances. And as our current monitoring system does not have these statistics readily available for our helpdesk, I was tasked with creating some scripts to allow them to give consistent replies before we set up a way for them to access our MDW. | |
| Aug 28, 2015 at 9:39 | history | edited | Reaces | CC BY-SA 3.0 |
added 1189 characters in body
|
| Aug 28, 2015 at 9:36 | comment | added | Shanky | Some more information could come if you share sample script. Are these monitoring scripts ? | |
| Aug 28, 2015 at 9:20 | history | asked | Reaces | CC BY-SA 3.0 |