Can't do it. We are using Replication to migrate the databases.

Thanks,

Fraggle

A couple of really good links for you to learn and hopefully help you:

http://msdn.microsoft.com/en-us/library/ms190030.aspx

http://msdn.microsoft.com/en-us/library/ms189931.aspx

One of the items I watch is the RedoQueueKB. Tells you how much data would need...

Quick and dirty.

Setup a continual ping to the servers.

Run the query

Do you see network packets dropping? If so, that is good proof that there is something wrong. Not...

To add to Sean's post above 2 other things to review.

1) If the query is dynamic, and isn't built correctly, each query could be generating a new execution plan, which...

gchappell (7/12/2013)

---

i am wanting to return the top 5 errors by hour. the following query returns all

select count(ERROR_LOG_NO) as ErrorCount, error_name, DatePart(Hour,ERROR_LOG_DATE) as ErrorHour, ERROR_SEVERITY

from my_table ...

At the principal, run:

-- This should tell the witness that it is no longer needed. Might have just had issues with the SSMS GUI.

ALTER DATABASE [DatabaseName] SET SAFETY OFF

--...

Please don't double post:

http://www.sqlservercentral.com/Forums/Topic1465160-1549-1.aspx

Fraggle

Just like the error states, the witness couldn't reach the principal for 10 seconds.

This could happen for any number of reasons. An extremely high work load that...

If you are still using 2005 and don't have Xevents, you could also use profiler. Brad McGehee has an excellent article here:

https://www.simple-talk.com/sql/sql-tools/how-to-identify-blocking-problems-with-sql-profiler/

Fraggle

I have done similar. We have a weekly restore of production to our internal environments for anything that isn't locked for development. An SSIS package was our approach....

atalders (5/8/2013)

---

Hi all--

We are going through the process of rationalizing our databases from SQL Server 2005 to 2012. In our development environment, however, we have many packages in SSIS...

The database isn't a mail server, so it has no way to register if someone received an email.

Your two best bets would be

1) Contact your network admin and have...

Current, there isn't a to do it outside of post-deployment scripts. The following article does provide a really nice walk through on how to handle it though:

http://blog.sqlconcepts.co.nz/2012/09/ssdt-sql-agent-job-deployment-template.html

Fraggle

DevDB (4/23/2013)

---

Flushing the entire cache, I think is never a good idea. But what I was more interested in to see the execution plan plan for the slow running sql...

DevDB (4/23/2013)

---

I think you must already have checked all these before but just wanted to ask?

Have you checked the execution plan for long running sqls/ stored procedures? It may be...