monitoring direct transactions thru isqlw

Question

Post reply

monitoring direct transactions thru isqlw

Faisal Haroon

SSC Journeyman

Points: 89
More actions
March 23, 2005 at 10:32 pm

#163963

hi,
We are using sql server 2k as backend for our ISP billing system. Our ISP manager wants to view all transactions that are made directly through queries by dba & his assistant (and not by the front-end application).
What is the best way to do it?
regards,
-Faisal
Regards,
-Faisal

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

wz700 SSCertifiable Points: 7133 More actions · Answer 1

sql profiler can help, use application name as filter

Faisal Haroon SSC Journeyman Points: 89 More actions · Answer 2

Sql profiler is a temporary solution. I want a permenant solution like anybody who is reading/ writing to database through isqlw at anytime, their queries should be logged.

Any suggestions?

Regards,

-Faisal

Johan Bijnens SSC Guru Points: 135550 More actions · Answer 3

also in that case you can use profiler to generate the script so you can capture all sql to a file.

Start profiler, create a trace and then save it as sql-trace-script.

This has less overhead then using the gui.

There are # of softwares (Quest software \ CA \ ... ) on the market to perform this monitoring. They ALL have an impact / overhead serverside, but have the advantage of build-in reportingfeatures. So that is a budget-factor

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me