Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[HOWTO] Logging ALL Queries on a MSSQL Database?

Initiate Mage
Joined
Dec 23, 2008
Messages
46
Reaction score
29
Hi,

after ALLOT of googling in found a very sweet function in mssql
If you have "Profiler" install here is how you can track almost everything that is going on in the DB

ive found out that it will take months (YES! months) to analyze all the data that is send from dekaronserver.exe
so here is how you can trace it:

Open SQL Server Profiler or Profiler

* File->New Trace
* The "General" Tab is displayed.
* Here you can choose "Save to file:" so its logged to a file.
* View the "Event Selection" Tab
* Select the items you want to log.
* TSQL->SQL:BatchStarting will get you sql selects
* Stored Procedures->RPC:Completed will get you Stored Procedures.

now all the data from dekaronserver is called by SP's or better called as "Stored Procedures"

there are actually about 500 gueries that the server run while its starting up

In the "Event Selection" you can add almost every action in the db, so you only need SQL->SQL:BatchStarting and Stored Procedures->RPC:Completed to view the db data

I know its allot of info but sadly i cant do that all by myself so ...
now you know how you can log queries

More info can be found on:

PS: DO NOT pm me about "mssql profiler" related questions, i dont know allot about it so ... use google ffs

MSSQL 2000 + 2005 + 2008 comes with Profiler, if you dont have it, re-install it


 
Back
Top