TheSQLGuru (2/27/2014)

---

SQLRNNR (2/27/2014)

---

you could run an extended event session to capture that since it looks like you are on 2012 and sql 2012 is more equipped and more friendly than...

you could run an extended event session to capture that since it looks like you are on 2012 and sql 2012 is more equipped and more friendly than previous versions...

Is your string supposed to be delimited by "/" or is that just a shortcut you used to represent different records?

Grant Fritchey (2/27/2014)

---

It sounds like blocking and resource contention. You'd need to monitor the server to see which queries are the ones that are being slowed down and then determine...

sphynx

Are the reports in SSRS or some other app?

+1

Interesting article.

You could also take advantage of sys.database_recovery_status

Yes, the domain migration could be impacting it.

You should have your AD guys verify the trust relationships and ensure the accounts from both domains have adequate permissions to each domain...

Here is an alternative script that could help with your trending report

DECLARE @SQLVer SQL_VARIANT

,@DBName VARCHAR(128)

,@NumDaysSMALLINT

,@SQLvarchar(1024)

,@WhereClauseVARCHAR(256)

SET @DBName = 'TFCCS_Transfers'

;

SET @NumDays = 90

;

SET @SQLVer = CONVERT(INTEGER, PARSENAME(CONVERT(VARCHAR(20),SERVERPROPERTY('ProductVersion')),4));

SET @WhereClause = 'WHERE a.type...

JoshDBGuy (2/26/2014)

---

You don't need to set up a central management server if you're the only DBA and you are only hitting one server.

You can run something like this,

CREATE TABLE #TEMP1...

Jeff Moden (2/26/2014)

---

There are two answers that I've grown accustomed to when working with any flavor of SQL. The first, of course, is "It Depends". The second one,...

If it is opening slow, do you have a very large job history retention?

Is there a time of day that they run slow all the time?

Are the reports being run with different parameters when they run slow?

Do you have any jobs running at...

SSIS, tsql, linked servers could help get the job done.

You would probably want to batch the migration. It wouldn't be hard to do it via a sql agent job...