Feature Requests for V2.0

Verison 2.0 is only in the "idea" stage at the moment, but I amware that what started off a quite a small project has exploded into what you see today. As such there are elements of the application that would have been coded differently had
they been planned in from the start, and there are a few other things I would have added in, but to do them now to version 1 would mean to much re-work.

Since Version 2.0 will be a fresh start, but still incorporating all the functionallity we have today, now is the time to chip in with those ideas.

The value in the ApplicationName parameter is displayed in the Program Name column.

This would be a good column to include in your current User Connections popup

That's actually information I'm gathering in another view (processes) although not via SP_who2. I see you point though, and yes it would be worthwhile adding it into the UserConnections form. I'll probably add that into version 1.29

I like this application. i will probably use it as a basis for a dashboard. Collect the data in one application and allow multiple people to view it through a different application. This is great as is if one person is monitoring.

selectDB_NAME(database_id) as 'DbName',[file_id],io_stall_read_ms,num_of_reads,cast(io_stall_read_ms/(1.0+num_of_reads) as numeric(10,1)) as 'avg_read_stall_ms',io_stall_write_ms,num_of_writes,cast(io_stall_write_ms/(1.0+num_of_writes) as numeric(10,1)) as 'avg_write_stall_ms',io_stall_read_ms + io_stall_write_ms as io_stalls,num_of_reads + num_of_writes as total_io,cast((io_stall_read_ms+io_stall_write_ms)/(1.0+num_of_reads + num_of_writes) as numeric(10,1)) as 'avg_io_stall_ms'fromsys.dm_io_virtual_file_stats(null,null)order by avg_io_stall_ms desc

A little CPU history derived from the ring buffers for a drilldown @ CPU

Some interesting stuff there for sure. There are a few problems with them though. Some of the column referenced are no longer present in 2008 from 2005, so unless they can be converted to something forward compatable, then I wouldn't be able
to use the query as it will be too limiting.

I'll need to do some performance tuning, and fix the syntax errors in the queries before I can see where they would fit in. Some great stuff there, but not sure they will all work given that this is a low overhead monitoring tool, and some of these
have quite an overhead. Running them on a resource constrained system could be enough to make it unresponsive.

I'll have a good play with them though to see which ones I can make work.

Verison 2.0 is only in the "idea" stage at the moment, but I amware that what started off a quite a small project has exploded into what you see today. As such there are elements of the application that would have been coded differently had they been
planned in from the start, and there are a few other things I would have added in, but to do them now to version 1 would mean to much re-work.

Since Version 2.0 will be a fresh start, but still incorporating all the functionallity we have today, now is the time to chip in with those ideas.

I have always wished for a performance monitor tool that wasn't designed "backwards". The reason I monitor is to find out if I need to change something. The perfect UI for this would one organized around the "changes" that could be made.
The main menu list would be something like this

1) Do I need to increase Disk space

2) Do I need to add memory

3) Do I need to increase network band with

4) Do I need to change the run time of a job

5) Do I need to ask the developers to change a querry

6) Do I need to ...

When a selection is made. the information needed to answer the question would be collected and displayed. Perhaps even with a small note on how each metric influences the answer ... Robin HC

change the title of the app in the taskbar to have the instance connected instead of SQLMonitor, e.g. "srv2301\sql2012 - SqlMonitor" so when we have multiple copies running you can flip between them easier - thanks for the great app!

Anglrzac: I was looking exactly for that: some kind of dashboard where I can see my 5-10 servers atop columns, and some basic health/performance items as rows under each one (page life expectancy, CPU%, locks longuer than 5 seconds, etc.)

I just downloaded this project, and was about to look into modifying it to do exactly this.

Get this to also archive the activity for later perusing, and you have a champion app on your hands here.