Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Monitoring Performance Expand / Collapse
Author
Message
Posted Saturday, May 24, 2003 12:00 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 8:44 AM
Points: 3, Visits: 88
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/vgorod/monitoringperformance.asp


Post #12522
Posted Monday, June 9, 2003 1:59 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, July 31, 2007 8:20 AM
Points: 885, 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"
Post #63684
Posted Monday, June 9, 2003 10:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 10:37 PM
Points: 28, Visits: 140
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



Post #63685
Posted Tuesday, June 10, 2003 4:10 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 18, 2005 8:25 AM
Points: 37, 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?




Post #63686
Posted Wednesday, June 11, 2003 6:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 8:44 AM
Points: 3, Visits: 88
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.





Post #63687
Posted Friday, June 13, 2003 11:33 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 12:51 PM
Points: 15, Visits: 161
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





Post #63688
Posted Monday, June 16, 2003 7:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 13, 2004 11:21 PM
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




Post #63689
Posted Wednesday, June 18, 2003 12:08 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, July 12, 2008 9:37 AM
Points: 12, 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.




Post #63690
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse