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 |
|
sonofgod
Starting Member
5 Posts |
 Posted - 2009-01-09 : 13:21:35
|
| Hello,I'm sorry if this has already been asked or explained on this forum but conducting a search did not find me what I need.I was wondering if there is a way or a program that can be used to see what databases/tables/query's/etc are being called/used to read/write data from a program such as a game server in my case. Sort of like a sql sniffer I guess. Any info would be greatly appreciated. Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-09 : 13:42:21
|
| you could use sql profiler to capture queries run on back end by your game |
 |
|
|
sonofgod
Starting Member
5 Posts |
Posted - 2009-01-11 : 10:06:55
|
| Thanks for the advice, I am using 2008, I do not have this tool :( |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-11 : 11:52:35
|
quote:
Originally posted by sonofgod
Thanks for the advice, I am using 2008, I do not have this tool :(
it comes with client tools. its found under start->programs->sql server2008->performancetools |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-11 : 13:30:11
|
| In SQL 2005 I use:PROFILER90.EXE in runThen it should be PROFILER100.EXE in 2008(Not sure about it). |
|
|
|
sonofgod
Starting Member
5 Posts |
Posted - 2009-01-12 : 14:17:26
|
| Oh, ya profiler is not supported for my SQL version |
|
|
|
sonofgod
Starting Member
5 Posts |
Posted - 2009-01-12 : 14:40:03
|
| well I remember I used to do this in cmd promt but i forgot the command line"c:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe" -sSQLEXPRESSwhats the command line like -n or -m to make it show all info instead of just the basic stuff? |
|
|
|
sonofgod
Starting Member
5 Posts |
Posted - 2009-01-12 : 16:31:03
|
| Nevermind fellas, I found a program that can do what I need, it's called xSQL Profiler. |
|
|
|
|
|
|
Quick question regarding SQL monitoring