Thanks Steve - issue is sorted now

Adding to what Grant said (I do use SQL Monitor and also other similar monitor tools).

one of the most important things is the ability to correlate different metrics that happened...

by the way you explain things it really looks like you know nothing of SQL Server permissions as this particular case is the most basics of access to any user.

Please...

that being the case then there is nothing preventing you from changing the stored procedure to behave better. May or not be possible but I have seen many cases of...

Steve said the essential - but...

I was on the Visual Studio marketplace the other day. Stumbled across this tool.

https://marketplace.visualstudio.com/items?itemName=MAQSoftware.SQLCodeCheck

I was hoping it would be a simple tool to root out basic issues in...

does not look like it - no duration, neither actual rows - only expected executions.

did you capture it yourself while executing it or through a monitor tool like SQL Monitor?

but...

that is an estimated plan, not the a actual execution plan - can you get the actual one please.

and also the view (and all sub called views).

in all likelihood all...

Do YOU maintain all of those servers or do most of the sub-companies have someone taking care of business for their...

Steve - any news on this issue?

good.

that is almost the same script I was going to send you (with a few modifications of mine)

90% of prod...

Sent you a private message.

big financial group - lots of sub companies/teams

small shop you have there.

Just on my side of the ocean we have over 750 servers (half is prod) - with a total size of 100 TB space used spread...

• This reply was modified 4 years, 2 months ago by frederico_fonseca.