New Born DBA (4/29/2014)
And I also mentioned that we are shrinking the DB every week
Why on earth would you do that?
There's nothing in what you show to go on. In fact, I can't see anything other than monitoring queries, nothing that looks like an application users use.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability