Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-07-15 : 15:39:26
|
| Has anyone been able to run SQL Profiler or Performance monitor remotely, without direct access to the server?Sam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-15 : 15:40:42
|
| I run SQL Profiler and Performance monitor remotely all of the time. I rarely log into the actual server. I have administrative privileges on these servers though. What permissions do you have on your remote servers?Tara |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-15 : 15:59:36
|
Hi Tara,I found how to login to the remote server using Profiler. I'm dangerous now.  Is there any recommended reading suggestions before I go?Sam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-15 : 16:02:00
|
| The below site has excellent information related to performance in SQL Server.[url]http://www.sql-server-performance.com/[/url]As far as books go...I like "Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook" by Ken England.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-15 : 16:22:19
|
| I found a loose intro in Ken Henderson. The web site you posted is full of lots more.I'd better try this on a test database first huh?Sam |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-07-15 : 16:42:22
|
| You won't hurt anything by running Profiler ... go ahead and see what's happening in your production database(s) if you like.Jonathan{0} |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-15 : 16:52:30
|
| SQL Profiler COULD hurt performance, but that's all that would be impacted. You might want to filter out some stuff such as the system IDs. You might also want to remove or add some events to profile. I typically send the results to a SQL table so that I can perform T-SQL on it, but it can also be sent to the screen and also a file.Tara |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-07-15 : 18:19:54
|
Thank you Tara and Jonathan.Right away, it's nice to see the time spent on the various procedures. I got an immediate SURPRISE by a procedure that really shouldn't be taking so long. Got to be missing an index.Off to figure that one now.Sam |
|
|
|
|
|
|
Console access for Performance Monitor