[dba-SQLServer] SQL RunTime/Performance (newbie)

Randy Sigmond rsigmond at comcast.net
Wed Nov 14 13:46:29 CST 2007


Francisco,

Thanks for the info.

Randy


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Wednesday, November 14, 2007 1:16 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL RunTime/Performance (newbie)

for capturing metrics you can download Idera's Diagnostic manager wich runs
on another server, then it simply runs sql statments to find the metrics you
are looking for, I would run a sql trace and capture these during your trial
period.  I personnallly just use their product as it provides a very useful
GUI to view all my problematic Sql Server instances.  Not to mention this
helps me find tables that need defragging and schedule such tasks for after
hours.

hope this helps

(www.idera.com)

If you don't want to install 3rd party software, there are scripts you can
find on www.sqlservercentral.com that will provide you with the data you
need, also I'd take a look at www.dbajournal.com for more useful
articles/scrpts to gather the information that you want.

--
Francisco

On Nov 14, 2007 9:29 AM, Randy Sigmond <rsigmond at comcast.net> wrote:

> 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
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com






More information about the dba-SQLServer mailing list