We are quickly moving from a small comapny to enterprise.
As it happens we want to watch SQL server (our bread and butter is data) more
cloely.
Weely/daily/monthly reporting, etc.
I am wondering if there is something like webtrends for SQL server. i.e. what
queries were called (or even tables), what stored procedures, how much bandwidth
was used, what the average return time, how much data was returned (in rows and
total size) etc.
In fact, if this can be done by hour of the day that would be a bonus. (or
concurrent connections through out the day)
Also, is there a tool much the same for Task Manager (Windows 2000) that can
keep a "long graph" for a day and save it somewhere (even better if it can tell
me what query was run at spikes, etc).
I am coming up empty looking for tools (is one built into SQL server?) but I
can't be the first person with this question.
John Mosey |..X..|....|Brew-o-meter
Exalted Grand Puba: http://www.fantasybaseballnews.com/
"...you look at slugging percentage and on-base percentage. I have a hard time
with that. I have a really hard time with that. I might be wrong, but I have a
hard time with it." .232/.277/.296 player and Twins manager Ron Gardenhire