Newbie Spellweaver
- 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
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:
You must be registered to see links
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
You must be registered to see links