The most recent content from our members.
The stored procedure having (Inserts is part of stored proc) is waiting for long time and Plan Hash showing Insert operation Clustered Index cost is 100%, Wondering how to resolve the issue ? The insert table has primary index and multiple non clustered indexes, wondering if excessive indexes will have any impact while…
We have some SQL Jobs disabled. somehow the jobs are enabled. Is there any way to find who and when the jobs are modified using SolarWinds DPA?
When I open a query plan to review, the message displays The plan 4022976130 does not have any text. Has the plan been purged from Cache? Is there a way to see the plan or query it from SQL?
I have drilled down in DPA and see the statement that I want to investigate. How do I tell what stored procedure it was run within or if it is being run directly (not from a stored procedure)? Thanks, Shawn
SQL Server - When I move a license to from server A to server B and now have a (Instance Not Licensed) by server A, does that mean that the monitoring has stopped on server A? As in no load, nothing running on it? Thanks
How can I fix this. I tried restarting the monitor but it still shows grey boxes. Thanks Steve
It looks like you're new here. Sign in or register to get started.