CirquedeSQLeil (3/16/2010)

---

I think this needs a...

roger.plowman (3/16/2010)

---

A very sobering read, as I'm embarking on the from-scratch rewrite of our company's backbone application to use SQL Server (basically it runs the company) and unfortunately I *am*...

any kind of performance spike is normal. sustained values are the problem.

I will note that with 4 instances on the box you are 'wasting' roughly 1/8th of your total...

Stay away from Embarcadero - hugely overpriced and limited actual monitoring stuff.

I highly recommend SQL Sentry's Performance Advisor. Contact Peter Shire (pshire@sqlsentry.net) and tell him TheSQLGuru sent you and...

I have a lot of clients that would be very happy to have your numbers on their machines. 😀

Nicely done. Lots of people just don't understand that data volumes can REALLY alter performance of existing code, and can also make the optimizer take different approaches to queries...

Isn't this all dynamic sql anyway? You do not need recompile on that stuff. Each unique...

Mani-584606 (3/15/2010)

---

It's>300

Yes, PLE reaches >300 in <2 mins

3) Are the...

As a point of reference, I spent several hundred hours a few years ago ELIMINATING/improving hundreds of indexes a company created by going hog-wild with Database Tuning Advisor. The...

You might be able to force the plan to be the same as the lower-memory one by using a plan guide. Or use hints to achieve the same result.

Mani-584606 (3/14/2010)

---

Hello,

Is that NORMAL to get low page life expectancy when the SQL server service fail over to passive node?

Because I'm seeing very low value of 4 for Page life...

mattfitz (3/12/2010)

---

Anyone ever use SQL Power Tools for SQL2008 ENT?

We inherited a custom app with substantial amount of generated dynamic tsql.

I need to identify the code being executed so it...

I highly recommend Performance Advisor from SQL Sentry.

There are a kajillion things that can affect performance. Read books, take classes, do the work for several years. If you are smart then by that point you...

Gail, we don't have enough information to know if 15GB is an appropriate amount of logging for his reorg/build. If the OP has 2TB of tables then 15GB could...