472,978 Members | 2,159 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,978 software developers and data experts.

APIs for monitoring MS-SQL

i want to retrive the information from MS SQL such as
o Active transactions
o Average wait time for lock requests
o Logical Scan – bytes/second
o Full Scans/Second
o Lock Blocks
o Lock Timeouts/second
o Log Cache Reads/second
o Log Truncations
o Logins/second
o SQL Agent\Failed SQL Agent Jobs
o SQL Server Backups\Failed SQL Backups
o SQL Server Replication\Merge\Conflicts/second.

i am searching for API for doing the above said function.
can anyone help me.
thanks in advance
Feb 7 '07 #1
1 1250
1,017 Expert 512MB
Not sure if API like this exists but you can definitely use system tables to get all necessary information.

Some of which you can pool using query like this:

[PHP]select spid, blocked, loginame,hostname, program_name,a.status,
login_time, last_batch, lastwaittype, b.name db_name, waittime/100 waittime
from master..sysprocesses a
join master..sysdatabases b on a.dbid = b.dbid [/PHP]
Feb 7 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Ron | last post by:
I am trying to run asp.net pages. The server is accessed via http://sitename/username I have verified it is using port 80 and aspx extensions are configured. But when I run and asp.net page I...
by: Tanuki | last post by:
Hi All: I am doing some development in VC++ using some llibraries downloaded from the web. The library comes in 3 files <mylib.dll>, <mylib.lib>, <mylib.exp> and I also have <mylib.h>. As...
by: cindy liu | last post by:
Hi, I'd like to create xml string based on my xsd file. Is there any .Net APIs to do this? Like in BizTalk 2004, you can generate xml instance based on xsd file. Thanks in advance!!! Cindy
by: johnm | last post by:
Hello, We currently are running a CRM application that uses DB/2 7.2 for the data repository. We will be upgrading to 8.2 later this year....maybe....time and resources permitting. The...
by: José Achig | last post by:
Hi I have to use functions inside of system apis so I want the correct dllimports declarations in c# for the following functions or information about where I can get these statements. +...
by: Jeff Reed | last post by:
I am experiencing the the problem outlined the below. Unfortunately, I am using WinXP and I not sure if I can apply the solution due to lack of security control Any feed back would be apreciated ...
by: Tim D | last post by:
Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...
by: Curtis | last post by:
Does anyone know of any good reference books for using the MS Exchange APIs to integrate a custom application with MS Exchange Server? Thanks Curtis Hunter
by: amit.vasu | last post by:
Hi I have created a web serivces using .net framework 2.0. When I try to execute the web service I get the following error. Failed to start monitoring changes to 'e:\Default Web Site' because...
by: RSL101 | last post by:
HI, I am hoping to get your opinions about "Tivoli Monitoring for Databases". Our enterprise environment is AIX/Red Hat Linux, running a lot of IBM P series and E servers. We need to monitor LUW...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.