Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 418

An ongong check of various statistics and events, which can be used to spot telltale signs of underlying issues.

3
votes
I have experience with the aforementioned idea. It's good, but a better idea would be to do something like Shawn said. What we did was to make a job that runs every 5 minutes and scans MSDB tables ab …
answered Aug 17 '11 by Marian
3
votes
Machanic's stored procedure sp_WhoIsActive. There are also many other external monitoring tools (some free, some paid) that you can use, but these ones are free and worth mentioning as a first step in your work. …
answered Feb 27 '12 by Marian
5
votes
Just to build on Aaron's and Kin's answers, you can do it with perf counters, but one of the user settable counters. I would: create a stored procedure that will use Aaron's query to get the free s …
answered Jun 8 '15 by Marian
1
vote
The 3rd party tools for which I've got some experience: Confio IgniteFree - very nice tool to monitor current and past 24 hours experience. Very useful for a first glance upon the server and see mos …
answered Aug 4 '11 by Marian