June 2, 2009 at 2:09 pm
Hi,
I just merged 2 databases into one and we pointed all our web application to the new database (all this on DEV environment).
How can I see what queries (or processes) are running right now? I tried Server profiler, but I’m not working on the server right now. I want to see what is going on my database from a client computer, where I do have an instance of SQL installed.
Any advice?
Regards,
June 2, 2009 at 2:58 pm
If your .sql code is stored procedures and functions you will see all under programmability if you double click your database in SMS. If it is not stored procedure then it maybe in your Data Access .NET or Java code, it helps if you have source code.
Kind regards,
Gift Peddie
June 2, 2009 at 3:03 pm
Im sorry, I guess I wasnt clear enough.
i just need to see what processes (queries, sp, etc) are running right now.
thank you
June 2, 2009 at 3:24 pm
You have to first find the sql code and find your application code calling your .sql code and watch with profiler. So there must be users using the application that is calling your sql code so you can watch with profiler.
Kind regards,
Gift Peddie
June 2, 2009 at 8:32 pm
sp_who3 is out there do search i not got code in front of me then run this in query it at least gives you some of the sql code..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply