[HOWTO] Logging ALL Queries on a MSSQL Database?

[janvier123]

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

after creating the topic and result from
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

[pieter]

profiler is a wonderfull tool to find out which event ingame, triggers what SP

thats how i've learned how dekaron communicates with the DB

[Decima]

****.

im speechless

ur a gentleman and a scholar









and a fking genius
hats off to you, ur the man.

[janvier123]

sadly i dont know much about SP's
but there are very powerful and easy to use, IF you know how

[MMOPerfection©]

**** bro, I must say, your doing a very outstanding job with the releases yo
keep it the F*** up!

[gedimazs]

have checked it out, and I can say WOW lots of info you can see there, how is everything working.

[janvier123]

Exactly, iam gonna try to make a tutorial about PHP queries
all queries from php send to the DB,
its easy to track all incoming scripts so ..

[Sunnysky]

Thx for this janvier123

[janvier123]

Recored at 1920 x 1080
Watch in full screen + 1080p