Creating a Dashboard

Question

Creating a Dashboard

Colin Betteley

Hall of Fame

Points: 3095
More actions
June 27, 2007 at 5:33 am

#76728

Hi,
Somebody has hit upon the idea of displaying some Database stats on our Intranet, in the form of a Dashboard. Counters such as Curent Logins, Bytes read. Bytes written. logins so far today etc. This data being stored in order to present graphs of performance/activity over periods of 7 days, 1 month and 3 months.
This is not as easy as it first appears. has anybody achieved this or have suggestions of a route to follow? Are there any system tables or stored procedures that I could use to fill a table with data?
Expect that the answer will be to buy a professional product, but the creation of a dashboard would be great for getting a better understanding of SQL internals.
Thanks for any comments.
Colin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Mark Harr SSCrazy Eights Points: 9921 More actions · Answer 1

While a few of the things you will want are available in SQL Server itself (e.g. active connections, database sizes), most of what you will want are provided by SQL Server to the Performance Monitoring services. You will access these items using WMI class (either in script or .Net objects, depending on how you write apps for your intranet).

You can get a feel for what items are available by running Performance Monitor on a server with SQL Server on it, and selecting from the various the SQLServer counters (several hundred different counters are listed there).

Hope this helps. Good luck.

Mark

Colin Betteley Hall of Fame Points: 3095 More actions · Answer 2

Mark,

Thank you for your response. I will explore this and see what can be achieved.

Colin

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

You might also use the sysperfinfo table. It's sometimes not that easy to read, but easily accessible through TSQL. See also here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=107424

Markus

[font="Verdana"]Markus Bohse[/font]

Ed Zann SSCrazy Eights Points: 8694 More actions · Answer 4

If you decide to go with a commercial product rather than something home grown, you might check out the SQLdm (Diagnostic Manager) product from Idera.

http://http://www.idera.com

I am currently using it to monitor and record stats for several SQL servers in our enterprise and I have been pleased with the results. It has a SQL repository database that can be used for custom reporting. It runs as a service on a server/workstation (in my case a VM) and periodically polls the configured SQL instances for statistics.