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...

>>We are facing severe performance probs on one of our prod servers.

I never understand posters who make statements like that and then hunt and peck on a forum for days...

If you know the database, user or application or even table for your critical stuff you can query various DMVs to see executing queries and the amount of effort (CPU,...