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 |
|
MarkHC
Starting Member
5 Posts |
 Posted - 2005-10-09 : 21:58:09
|
| Hey guys, i'm trying to troubleshoot some problems with one of our machines running queries against a seperate sql server.I need to run a profile on our main database (lets call it MAINDB) to filter and show only queries made from a gateway running on another machine (EXTPC) so i can see which queries from EXTPC are having performance issues, i'm not very good at using profiler or creating traces etc yet, so any help would be much appreciated.Any ideas?Mark |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-10-09 : 23:14:37
|
| How far have you gotten with it ?The filters section of profiler is fairly straight forward, it uses the same syntax as a LIKE expression.The column to filter on is HostName. i.e. HostName -> Like -> %EXTPC%Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
MarkHC
Starting Member
5 Posts |
Posted - 2005-10-10 : 01:02:11
|
| Hey thanks Markin, I worked it out, it's running now, thanks for your help. |
|
|
|
|
|
|
SQL Profiler Filters