Simply post the DDL into your reply, and if you want to get all fancy place it between the [ code ="sql"] INSERT TSQL HERE [/ code]

Of course remove the...

I think the spid 51 might be the culprit - Can you temporarily comment out the code in the attached script? I mean, if this is the issue and...

@Sean...THAT's AWESOME 😀

While others may advise against it, I use a server side profile trace that runs continuously on the server (see to automatically start each time the MSSQL service is started)....

Does your SQL Agent's execution/proxy account differ from the CRM account? If so you may be able to determine the "caller" and use a CASE statement to bypass the...

What is running under spid 51?

That's actually good question...indirectly asking how well you know how things are set up within the SQL Agent - so what was your answer?

This isn't pretty but it works well - I just threw it into a Job running hourly

CREATE PROCEDURE [dbo].[utl_dba_CheckSQLJobsForErrors]

@notifyEmailGroup varchar(300) = 'dba_alerts@company.com'

AS /*

USED TO MONITOR MSDB...

Sorry but it seems I misunderstood your initial request. I read (mis-read) that you were dealing solely with SharePoint data and thought you just needed advice using multiple data...

If there's not many NCI's contributing to the overall size of the datafile, I wouldn't bother with it

100GB isn't really that large...but that being said, can you let us know what that space comprises of? Are there many non-clustered indexes? If there are, I'd recommend...

Chances are you can find your bad query by looking at the logical_reads, elapsed/worker_time, etc by using this:

SELECT

*

FROM

sys.dm_exec_query_stats qs

INNER JOIN sys.dm_exec_cached_plans cp

...

Great suggestions. Can I ask what version of SQL Server you are using? Depending on your version you may have the ability to compress your backups with SQL's...

+1 @craig-2 regarding "set delayValidation to True"

You will find this setting on nearly every control and I believe on the package level itself

Let me rephrase: As long as you restored the database backup to a new database, or overwrote one that's not the actual production...