Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ken Simmons Return Query Text Along With sp_who2 Using Dynamic Management Views RE: Return Query Text Along With sp_who2 Using Dynamic Management Views
Ken Simmons
SSCertifiable
Points: 7822
More actions
July 10, 2008 at 5:16 pm
#841170
It is not process intensive. Many people use sp_who2 to get a quick view of what is going on on the server. This is by no means a replacement for profiler, but it does give you a quick snapshot of what is happening on the server.