When I run this on our production system it generates about 12,500 rows of execution plans that are usecounts=1 About 500 are "adhoc," the rest Prepared. ...

ALZDBA (3/11/2011)

---

Michael Valentine Jones (3/11/2011)

---

Have you implemented table partitioning? With online index rebuilds of only the partitions that are fragmented, you should be able greatly reduce the amount of...

I do plan to read that article even though we're not on sql 2008 yet. As well as another one shown in that article

http://sqlblogcasts.com/blogs/sqlandthelike/archive/2010/01/27/cleaning-up-sys-dm-exec-cached-plans.aspx

The first "h" in http wasn't part of the link.

http://www.sqlskills.com/BLOGS/KIMBERLY/post/Plan-cache-adhoc-workloads-and-clearing-the-single-use-plan-cache-bloat.aspx

We're definitely not Amazon. Management seems to think we can get the maintenance done quickly no matter how large the system. And the reason we can't is I'm...

ALZDBA (3/11/2011)

---

Can you elaborate on the "We seem to have solved a major IO problem last weekend so we'll see how long it runs this weekend." ? ...

Update stats was run just prior to this past Sunday's systems work, as always. We use a commonly available stored procedure for this ( this one I believe ...

We have numerous sql data files for this database, on separate Netapp luns. However in recent discussions here and elsewhere, the value of splitting the database out into numerous...

[font="Tahoma"]I would look at reducing the number of datafiles you are using - it's probably too many (17 data and 1 log by my count). [/font]

[font="Arial"]I'm beginning to...

CirquedeSQLeil (3/1/2011)

---

Indianrock (3/1/2011)

---

Actually now I'm hearing that MPIO is not on. Systems is still looking into all of that. Each of the data and log files shown...

Each of those mdf, ldf, ndf files it's on it's own lun on the Netapp. But aside from "disk busyness" it's what we've referred to as the separated "IO...

We have a sql 2005 Enterprise 64-bit active/passive cluster running on Windows 2008 Server 64-bit connected to a Netapp. There may only be one HBA network card in active...

Actually now I'm hearing that MPIO is not on. Systems is still looking into all of that. Each of the data and log files shown below is...

We're on sql 2005 Enterprise and do have some indexed views in use. How would that work for this problem?

It will be up to the developers to decide if they're going to revise anything. Unless Systems decides to "insist" I've done a lot...