467,864 Members | 1,915 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,864 developers. It's quick & easy.

Counting number of IO Accesses per DB

Hello,

I am trying to write a VB.NET monitoring application for a MS SQL
server.
For that I need to know the following:
1. How do I count the number of read/write accesses per database on
the server since the creation of the DB?
2. How do I get the last access time of the database ?

Any inputs would be really appreciated.
Thanks in advance.

-Sourabh
Jul 20 '05 #1
  • viewed: 1655
Share:
1 Reply
Thanks Geoff....

--------
Re: Counting number of IO Accesses per DB
From: Geoff N. Hiten
Date Posted: 4/13/2004 3:02:00 PM

The basic building block you are looking for is the T-SQL function
fn_virtualfilestats. You can use write a query, call it from ADO.Net, and
do something nifty to display the results using VB.Net.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

mo*****@auburn.edu (Sourabh) wrote in message news:<cf**************************@posting.google. com>...
Hello,

I am trying to write a VB.NET monitoring application for a MS SQL
server.
For that I need to know the following:
1. How do I count the number of read/write accesses per database on
the server since the creation of the DB?
2. How do I get the last access time of the database ?

Any inputs would be really appreciated.
Thanks in advance.

-Sourabh

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Megan | last post: by
18 posts views Thread by ChadDiesel | last post: by
7 posts views Thread by sathyashrayan | last post: by
2 posts views Thread by Brad B. | last post: by
reply views Thread by Chris Thomasson | last post: by
10 posts views Thread by Dmitriy V'jukov | last post: by
3 posts views Thread by nitric | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.