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 [Only registered and activated users can see links. Click Here To Register...]
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: [Only registered and activated users can see links. Click Here To Register...]
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
after creating the topic and result from [Only registered and activated users can see links. Click Here To Register...]
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: [Only registered and activated users can see links. Click Here To Register...]
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
|
|