October 22, 2018 at 9:56 am
I'm spoiled by having admin access to SQL Server so I'm at a loss on how to get SQL info (i,e, what a process or spid is doing) when my access is limited to that of the database.. The process I'm trying to get this info for are connected o and working in the DB I am the DBO of .
We can't use Profiler (don't have alter trace access) and Activity Monitor will not work. I can execute sp_who/sp_who2 but that doesn't give me the details of what the processes are doing.
Ideas/Suggestions?
I've requested that we get the ALTER TRACE access to use profiler but I have a felling that's going to be denied even though the SQL Server and the Windows Server are both private to our use b/c the company we're dealing with doesn't like for their clients to have access to troubleshoot issues.
Kindest Regards,
Just say No to Facebook!October 22, 2018 at 1:56 pm
YSLGuru - Monday, October 22, 2018 9:56 AMI'm spoiled by having admin access to SQL Server so I'm at a loss on how to get SQL info (i,e, what a process or spid is doing) when my access is limited to that of the database.. The process I'm trying to get this info for are connected o and working in the DB I am the DBO of .We can't use Profiler (don't have alter trace access) and Activity Monitor will not work. I can execute sp_who/sp_who2 but that doesn't give me the details of what the processes are doing.
Ideas/Suggestions?
I've requested that we get the ALTER TRACE access to use profiler but I have a felling that's going to be denied even though the SQL Server and the Windows Server are both private to our use b/c the company we're dealing with doesn't like for their clients to have access to troubleshoot issues.
Do you see all processes or just your own with sp_who2? If you have view server state permissions, you have access to the DMVs to collect more details, such as sys.dm_exec_requests, sys.dm_exec_sql_text, etc.
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply