Any tool to give me some live metrics

Id like a nice front end that I can drop to get the server I want or even
combine multiple perfmon sessions for servers in one look and feel.
I also want to look at event logs, current OS /SQL info.. Current
applications running...etc..
Right now, if i have to go to the logs, i have to go to the manage
properties of My computer.. and connect to the server..
Also open Perfmon and select the server.. or even worse, log on to the
server itself to look at current running processes.. I want to make our job
easier by having this one console that i can just drop down on the server I
want and it gives me most of the live info..Something with a web interface
would also be better..
You could check http://www.imceda.com/Product.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eznApwkBFHA.3616@.TK2MSFTNGP11.phx.gbl...
> Id like a nice front end that I can drop to get the server I want or even
> combine multiple perfmon sessions for servers in one look and feel.
> I also want to look at event logs, current OS /SQL info.. Current
> applications running...etc..
> Right now, if i have to go to the logs, i have to go to the manage
> properties of My computer.. and connect to the server..
> Also open Perfmon and select the server.. or even worse, log on to the
> server itself to look at current running processes.. I want to make our
job
> easier by having this one console that i can just drop down on the server
I
> want and it gives me most of the live info..Something with a web interface
> would also be better..
>
|||Hello Hassan,
Check out http://www.quest.com/Quest_Central_f...agnostics.asp. We have a lot of other SQL Server tools which you can see at http://www.quest.com/Quest_Central_for_SQL_Server.
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> Id like a nice front end that I can drop to get the server I want or
> even combine multiple perfmon sessions for servers in one look and
> feel.
> I also want to look at event logs, current OS /SQL info.. Current
> applications running...etc..
> Right now, if i have to go to the logs, i have to go to the manage
> properties of My computer.. and connect to the server..
> Also open Perfmon and select the server.. or even worse, log on to the
> server itself to look at current running processes.. I want to make
> our job
> easier by having this one console that i can just drop down on the
> server I
> want and it gives me most of the live info..Something with a web
> interface
> would also be better..

Any good link on tracking memory issues

I have always found it hard to figure out if SQL has memory issues using
tools like perfmon,etc..
Its easy for CPU and IO i.e. high CPU or disk queue, but could never figure
out how to go about memory.
Yes some may say look at DBCC memorystatus,etc.. but that things greek ;)
Can someone help or maybe theres some documentation that talks about
tracking memory usage,etc. for SQL Server..Hi Hassan,
Two excellent sources I know are:
Paper "Troubleshooting Performance Problems in SQL Server 2005"
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx
Chapter 1, book "Inside SQL Server 2005: Query Tuning and Optimization"
by Kalen Delaney, et al.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Hassan" wrote:
> I have always found it hard to figure out if SQL has memory issues using
> tools like perfmon,etc..
> Its easy for CPU and IO i.e. high CPU or disk queue, but could never figure
> out how to go about memory.
> Yes some may say look at DBCC memorystatus,etc.. but that things greek ;)
> Can someone help or maybe theres some documentation that talks about
> tracking memory usage,etc. for SQL Server..
>
>

Any downloadable tool to chart my perfmon data ?

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the
SQL database without writing any code ?
Thanks
Have you looked at SQL Server Reporting Services?
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:uSKfHsfSIHA.2000@.TK2MSFTNGP05.phx.gbl...
>I am collecting perfmon data in a SQL database but I dont know how to write
>any web code,etc. to display the contents in a chart so I can look at the
>data over a specified time range.
> Are there any tools out there that I can download and just point it to the
> SQL database without writing any code ?
> Thanks
|||Hassan wrote:
> I am collecting perfmon data in a SQL database but I dont know how to
> write any web code,etc. to display the contents in a chart so I can look
> at the data over a specified time range.
> Are there any tools out there that I can download and just point it to
> the SQL database without writing any code ?
This may be one of those things that's not as hard as you think. Go
into Excel, connect to your external data source then use the chart wizard.
Hal Rottenberg <hal@.halr9000.com>
Author, TechProsaic (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Co-host, PowerScripting Podcast (http://powerscripting.net)

Any downloadable tool to chart my perfmon data ?

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the
SQL database without writing any code ?
ThanksHave you looked at SQL Server Reporting Services?
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:uSKfHsfSIHA.2000@.TK2MSFTNGP05.phx.gbl...
>I am collecting perfmon data in a SQL database but I dont know how to write
>any web code,etc. to display the contents in a chart so I can look at the
>data over a specified time range.
> Are there any tools out there that I can download and just point it to the
> SQL database without writing any code ?
> Thanks|||Hassan wrote:
> I am collecting perfmon data in a SQL database but I dont know how to
> write any web code,etc. to display the contents in a chart so I can look
> at the data over a specified time range.
> Are there any tools out there that I can download and just point it to
> the SQL database without writing any code ?
This may be one of those things that's not as hard as you think. Go
into Excel, connect to your external data source then use the chart wizard.
Hal Rottenberg <hal@.halr9000.com>
Author, TechProsaic (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Co-host, PowerScripting Podcast (http://powerscripting.net)

Any downloadable tool to chart my perfmon data ?

I am collecting perfmon data in a SQL database but I dont know how to write
any web code,etc. to display the contents in a chart so I can look at the
data over a specified time range.
Are there any tools out there that I can download and just point it to the
SQL database without writing any code ?
ThanksHave you looked at SQL Server Reporting Services?
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <hassan@.test.com> wrote in message
news:uSKfHsfSIHA.2000@.TK2MSFTNGP05.phx.gbl...
>I am collecting perfmon data in a SQL database but I dont know how to write
>any web code,etc. to display the contents in a chart so I can look at the
>data over a specified time range.
> Are there any tools out there that I can download and just point it to the
> SQL database without writing any code ?
> Thanks|||Hassan wrote:
> I am collecting perfmon data in a SQL database but I dont know how to
> write any web code,etc. to display the contents in a chart so I can look
> at the data over a specified time range.
> Are there any tools out there that I can download and just point it to
> the SQL database without writing any code ?
This may be one of those things that's not as hard as you think. Go
into Excel, connect to your external data source then use the chart wizard.
Hal Rottenberg <hal@.halr9000.com>
Author, TechProsaic (http://halr9000.com)
Webmaster, Psi (http://psi-im.org)
Co-host, PowerScripting Podcast (http://powerscripting.net)