Re: sqldmo
From: Anthony Thomas (ALThomas_at_kc.rr.com)
Date: 02/19/05
- Next message: Anthony Thomas: "Re: Running multiple instances in production environment. Good or bad?"
- Previous message: Anthony Thomas: "Re: registering servers"
- In reply to: Dan Guzman: "Re: sqldmo"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 19 Feb 2005 12:10:50 -0600
I like the idea of using WMI because you can get both OS and SQL Server
performance counters. Also, as a suppliment on the installation medi, there
are special WMI objects tailored to SQL Server specifically, SQLWMI.
However, if you are only interested in SQL Server statistics, consider T-SQL
statments against master.dbo.sysperfinfo, master.dbo.sysprocesses, and
master.dbo.syslockinfo. Also, consider using DBCC INPUTBUFFER and
fn_get_sql.
Sincerely,
Anthony Thomas
-- "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> wrote in message news:emtnC2RCFHA.208@TK2MSFTNGP12.phx.gbl... For performance counters, consider WMI queries. This can be used to get SQL Server as well as OS metrics. You'll find a lot of examples with a google search. -- Hope this helps. Dan Guzman SQL Server MVP "Aju" <ajuonline@yahoo.com> wrote in message news:uIStYxRCFHA.3336@TK2MSFTNGP11.phx.gbl... > Thanks for reply guys > I meant , want to make an application to see how my server is performing > for > e.g. buffer cache hit ratio , memory usage , procedure cache hit ratio or > from OS processor queue length . > > Thanks > ARR > > "Mark Allison" <mark@no.tinned.meat.mvps.org> wrote in message > news:#FjL7sRCFHA.1292@TK2MSFTNGP10.phx.gbl... >> Aju, >> >> I'm not clear what you're trying to do. SQL-DMO is used for managing SQL >> Server programmatically. i.e. much of Enterprise Manager functionality >> is available in your front-end code in SQL-DMO. >> >> For data storage and retrieval, it is better to use ADO (or even ADO.NET >> for .NET apps). SQL-DMO is not designed for data storage and retrieval, >> rather it is used to manage your database servers. >> >> What does "making a small application for performance" mean? >> >> -- >> Mark Allison, SQL Server MVP >> http://www.markallison.co.uk >> >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602m.html >> >> >> Aju wrote: >> > Hi , >> > Just for curiosity making a small application for performance . Is it > good >> > to use SQL-DMO in the application for better performance of it rather > than >> > storing the data in sql database & retriving . >> > >> > Thanks >> > ARR >> > >> > > >
- Next message: Anthony Thomas: "Re: Running multiple instances in production environment. Good or bad?"
- Previous message: Anthony Thomas: "Re: registering servers"
- In reply to: Dan Guzman: "Re: sqldmo"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
