SQLRNNR (4/13/2015)

---

Grant Fritchey (4/13/2015)

---

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/13/2015)

---

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/11/2015)

---

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include...

Brandie Tarvin (4/13/2015)

---

edyeh (4/13/2015)

---

I did an analysis showing procs that use high I/O and cpu resources, but I'd like to isolate the procs using the tempDB the most without going...

Especially when doing an ONLINE rebuild, it's a combination of the transaction you're running to rebuild the indexes (might want to break that down to smaller transactions) combined with the...

Yes. A query hash is based on the query itself. So:

DBCC CHECKDB('Myfirstdatabase')

Is going to have a different hash value than:

DBCC CHECKDB('ADifferentDatabaseEntirely')

No shocks there at all.

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/13/2015)

---

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/11/2015)

---

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries,...

The biggest part of the undertaking won't be making the calls to the objects. The biggest part of the work is all the modifications you'll have to make to all...

I'm with Gail.

Although, if you wanted to you could make this a derived table and then GROUP BY the function. But I don't think it will help your performance any....

If you're getting lots of inserts there's a good chance that during the day a healthy chunk of the information added to the table are falling outside of the statistics....

The biggest question is are you using Enterprise functionality? If so, going to Standard, regardless of version is going to be an issue.

You're making a modification to your server. Regardless of how "safe" that modification might be, yes, I'd make darn sure I have backups in place and that I've tested those...

Always On is a marketing term.

The two different services are failover clustering and availability groups. Failover clustering is...

SQLRNNR (4/13/2015)

---

Grant Fritchey (4/11/2015)

---

I'd suggest checking out Jonathan Kehayias article in Simple Talk on monitoring tempdb usage through extended events[/url]. If it doesn't include capturing the queries, you can just...

Yeah, it absolutely sends confirmation messages back. I wouldn't imagine that those, under most circumstances, are going to cause huge performance issues, but they absolutely do happen.

Looks like a blog recommendation. Not a big deal to post those on SQL Server Central, but instead of putting it into the general forums which are usually reserved for...

Looks like the exact same question over at ASKSSC. I gave very similar advice there.

If ever you wondered why so much emphasis is placed on backups, testing backups, ensuring backups...