SQL Server 2005 - Get list of queries ran
-
Can anyone tell me the best way to get a list of all the queries ran against a particular database on my server? I don't need queries ran against System Tables only the tables I've defined. As mention in the subject, it's SQL Server 2005. I've ssearched the Web as well as help files but apparently I'm not using the correct keywords in my search as I haven't found anything.
"Half this game is ninety percent mental." - Yogi Berra If you can read thank a teacher, if you can read in English, thank a Marine.
-
Can anyone tell me the best way to get a list of all the queries ran against a particular database on my server? I don't need queries ran against System Tables only the tables I've defined. As mention in the subject, it's SQL Server 2005. I've ssearched the Web as well as help files but apparently I'm not using the correct keywords in my search as I haven't found anything.
"Half this game is ninety percent mental." - Yogi Berra If you can read thank a teacher, if you can read in English, thank a Marine.
-
I would get a good sql log file parser. There are some good tools out there. The information you want is only in the log files. Hope that helps. Ben
Ok, I'll try that, but I also thought SQL Server 2005 has a lot of new statisitcs and usage reporting built in?
"Half this game is ninety percent mental." - Yogi Berra If you can read thank a teacher, if you can read in English, thank a Marine.
-
Can anyone tell me the best way to get a list of all the queries ran against a particular database on my server? I don't need queries ran against System Tables only the tables I've defined. As mention in the subject, it's SQL Server 2005. I've ssearched the Web as well as help files but apparently I'm not using the correct keywords in my search as I haven't found anything.
"Half this game is ninety percent mental." - Yogi Berra If you can read thank a teacher, if you can read in English, thank a Marine.
I would suggest use SQL profiler tool, and start the session. That will record all the queries that are running on the DB. Hope that solves your problem
Regards, Jaiprakash M Bankolli jaiprakash.bankolli@gmail.com