SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Monitoring Performance


Monitoring Performance

Author
Message
vgorod
vgorod
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 213
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/vgorod/monitoringperformance.asp



ckempste
ckempste
Hall of Fame
Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)Hall of Fame (3.1K reputation)

Group: General Forum Members
Points: 3083 Visits: 1
Hi Victor

Excellent article and very well thought out scripts with examples.

Cheers

Ck


Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Allan Agnew
Allan Agnew
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 189
I've been able to use the first two listings "out-of-the-box" on SQL7 and they are really useful, and just what I've been looking for. Unfortunately the one which builds a trace uses fn_trace_getinfo which seems to be only valid in sql2k. Would it be possible to tell us how to do this in sql7?

Thanks



msurasky
msurasky
SSC Journeyman
SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)SSC Journeyman (93 reputation)

Group: General Forum Members
Points: 93 Visits: 1
I want to ask apologize in advance if my eyes are out of focus but as much as I have seen, the listings do not appear (not directly in the page nor as a link)... The article so far seems very accurate and useful... but, where are the listings?



vgorod
vgorod
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 213
Allan,

spTraceBuild must be totally re-written to work in sql7, not just the line with the function fn_trace_getinfo (which BTW can be simply taken off). If you ever run traces programmatically in sql7 you know that it's doable. It's only an issue of spending time.

Since the traces have been collected they can be processed on any installation of sql2000.



rlufinha
rlufinha
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 164
Hi Victor,

Very good article.
But I have one question: this scripts run on the database server, isn't it? I know that this store procedures (sp_trace_xxx) use less server resources than does the Profiler tool itself, but aren’t to heavy on the server? Is possible to use this sp remotely?

Thanks
Rui



glecko
glecko
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 1
Looks like some very useful stuff .... now if we could output it to a web page ... ah ...

Since this piece is on performance management, I was suprised to see no mention of added load by all this monitoring. I'm sure it maight be somewhat minimal, but it's got to add load ... and as more 'consumers' use the server, does the imapct of this monitoring go up?

Just curious.

Greg



Murad_J30
Murad_J30
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 2
Hello Victor,

I am about the scripts you have placed to use. Do other scripts, except sp_trace... one work on SQL Server 7.0 or they need to be rewriten as well ?

If that only one , then how difficult would it be to rewrite it to run on SQL7.0 ?

Regards,
Murad.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search