Viewing 15 posts - 916 through 930 (of 1,583 total)
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 12, 2012 at 8:55 am
@sean-2...THAT's AWESOME 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 11, 2012 at 12:58 pm
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)....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 11, 2012 at 10:15 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 11, 2012 at 10:09 am
What is running under spid 51?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 11, 2012 at 9:54 am
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?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 11, 2012 at 7:56 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 10, 2012 at 4:09 pm
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2012 at 1:12 pm
If there's not many NCI's contributing to the overall size of the datafile, I wouldn't bother with it
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2012 at 10:47 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 6, 2012 at 10:39 am
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
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2012 at 8:47 am
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...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2012 at 7:57 am
+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
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 5:45 pm
The backup was restored to the same server.
Let me rephrase: As long as you restored the database backup to a new database, or overwrote one that's not the actual production...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 3:16 pm
Restoring a backup to a different server has no impact whatsoever on the original server the backup was created from. Are you using a maintenance plan per say or...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 29, 2012 at 3:04 pm
Viewing 15 posts - 916 through 930 (of 1,583 total)