You can also create a performance alert: http://www.databasejournal.com/features/mssql/article.php/1498781/SQL-Server-Agent---Creating-Performance-Condition-Alerts-on-Database-Server-Objects.htm

If you take something from a blog, please give credit to the source. Someone else wrote this, so ensure they get the credit...

I haven't seen this, but it looks like a CPU bottleneck. Do you have parallelism enabled (MAXDOP)? Is the CPU saturated when this occurs?

Log space cannot be reused until a transaction is committed and a checkpoint run. If you have one large transaction, it prevents reuse of the log file.

Setting to simple, do...

This scenario isn't clear at all. What do you mean attributes sharing? ARAIK, Attributes are not a term that is defined as a particular thing in SQL Server. Do you...

Also, for "first" to you mean lowest numerical value? SQL Server has no concept of the ordering of rows, so you need to be clear about which one of the...

Rocks win another 4 in a row! Amazing, we're now a game out of first in NL West and barely a mention by ESPN.

All-star game, remain an exhibition. Ultimately it...

I don't think that this is the error you get when SQL authentication is turned off. If you check on the Security tab of the Properties for this SQL Server,...

I like DaniSQL's list, might add some storage knowledge as well (SAN/fiber/disk performance)

You could also reuse this on DB1, let it also then send out alerts for itself.

Sounds like a good solution.

Congrats, Jeff. Looking forward to meeting you as well

sing4you (7/9/2010)

---

dbowlin (7/9/2010)

---

Like most of you I probably won't stop 'till I drop. Even then the bills may keep coming.

I am not sure whether to attach a 🙂 or...

http://www.iana.org/assignments/port-numbers

I can't find anything that mentions it. I think it's 50-50 it works.

Do you have a dev environment that dups your setup? I'd get one setup, even in VMs, and...

http://msdn.microsoft.com/en-us/library/aa213778%28SQL.80%29.aspx

What type of replication?

Some info: http://msdn.microsoft.com/en-us/library/ms151870%28v=SQL.90%29.aspx