Thank you all for your help.

I was aware that MAXDOP was related to #CPU's.

The white paper is excellent,...

Apollo74x (11/14/2008)

---

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=626299&SiteID=1

Apparently using replication monitor causes this problem. I'm going to reiniatalize our replication tonight, not use replicaton monitor for a week and see if this is really the...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=626299&SiteID=1

Apparently using replication monitor causes this problem. I'm going to reiniatalize our replication tonight, not use replicaton monitor for a week and see if this is really...

TheSQLGuru (10/9/2008)

---

I have seen a number of my client's servers where the wmiprvse.exe process routinely exhibits excessive paging. If anyone can tell me why this may be occurring...

I enabled the allow page locks on all of the indexes.

I searched sys.syscomments and I couldn't find any sp's that used the rowlock hint.

I'm gathering the performance counters again to...

Nikhil Shikarkhane (10/8/2008)

---

Going by High Keylocks and RID,

1. check if your stored procs are explicitly using ROWLOCK table hints while accessing the tables ( tip : search syscomments or...

I checked back with the counters that I'm grabbing and I do have pages/sec (spoke too soon). I just had to add it to my report.

Pages/sec on average is...

Nikhil Shikarkhane (10/3/2008)

---

Page faults happen when a thread being processed doesnt find the required data in the physical memory and has to page it into the memory.

Your problem looks like...

This is working now.   I was trying to set my security settings from the actual package withing Business Intelligence Solutions.  I finally noticed the greyed out security settings on the...

Thanks all.  I'll try these different options.

James