| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-08-09 : 16:00:01
|
Is SQL Profiler the tool used to generate graphs like in the article[url]http://www.sql-server-performance.com/bl_asp_ado.asp[/url]If so, how is Profiler configured to generate this particular graph of open connections?Sam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-09 : 16:03:44
|
With a really small screen size, it seems.  |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-08-09 : 16:09:59
|
| Ha !Well I've hooked my palm pilot to the outboard VGA of my laptop to duplicate the screen size.Now what?Sam |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-09 : 16:13:21
|
| The article says he's using Performance Monitor to generate the graphs. I don't think Profiler graphs anything by itself, but you might be able to take its data and graph it in something like Excel. |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-08-09 : 21:22:51
|
| Would be nice if the graphs were integrated.I don't see any way to monitor connections in SQL PM. It must be disguised under another name.Sam |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-08-09 : 21:48:32
|
| SQL Server:General Statistics - User Connections |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-08-11 : 10:44:01
|
| Rob,SQL Profiler has no SQL Server: General Statistics Sam |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-08-11 : 12:31:41
|
| Sam-Rob's talking about the Performance Monitor in the operating system, perfmon.exe, not SQL Profiler.Jonathan{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 12:33:53
|
| The graph is from Performance Monitor and not from SQL Profiler.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-08-11 : 12:43:21
|
| Thanks Tara,Looks like I don't have Performance Monitor installed. Where are those SQL installation CDs?Sam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 12:49:55
|
| Performance Monitor is not a SQL Server tool. It comes with Windows. You will find it in the Administrative Tools program group.Tara |
|
|
|
|
Performance Monitoring