Randy Sigmond
rsigmond at comcast.net
Wed Nov 14 11:29:52 CST 2007
John, The goal of my exercise is to capture run-time/performance information remotely from SQL and extract (via Store Procedures or Dynamic Views) the information into a local database for analysis. This will provide a status of the server and allow for the identification of problem areas that can then be handled on the remote server. Arthur, Thanks for the links, but do you know of any specific (sp or dmv) that you know of that will provide run-time information. Being relatively new to SQL I am still struggling with the understanding of run-time environment. Any help would be greatly appreciated. Randy Sigmond -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, November 14, 2007 11:22 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL RunTime/Performance (newbie) Hi Randy, First, to pose a question, just send a new email addressed to dba-sqlserver at databaseadvisors.com. Give it a subject appropriate to the question, click Send and wait for answers. Second, here are a few URLs to read: http://www.sql-server-performance.com/articles/per/tuning_for_executives_p1. aspx http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1185283,00.html http://msdn2.microsoft.com/en-us/library/ms189081.aspx hth, Arthur On 11/14/07, Randy Sigmond <rsigmond at comcast.net> wrote: > > John, > > This might not be the proper format, but I have not posted in a very, very > long time and I cannot seem to find out how to post a question. So here it > goes. > > I have been sitting on the wings learning from all of the emails that > receive from DBAdvisors.com and now I have a question of my own. > > I am looking for some guidance on a couple of issues. > > 1. SQL Performance Metrics > 2. SQL Run-Time Metrics > > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com