updating the stats also didnt help. Queries do not really give the same result, but same number of records..I dont know where else to look for

Yes same value is passed. I am updating the statistics now, lets see..

hmm..so what is best way to find fragmentation level on indexes during heavy usage?

Thanks for quick reply. I am trying to understand this in a better way, if your script doesn't match the indexes what are actually used then where can i use...

Thanks for the wonderful article Ian. As soon as i read this article i tested this out on one of our development environments. I compared the results from your code...

Are high memory\page cache faults good?

Sachin Nandanwar (2/1/2011)

---

You are welcome.

Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page...

Sachin Nandanwar (2/1/2011)

---

You are welcome.

Yes you need to trace Memory\ Page Reads /sec.If those value are also high along with Memory\Page Faults/sec then it will indicate a hard page...

Sachin Nandanwar (2/1/2011)

---

All counters look fine for me except Memory\Page Faults/sec which are way over the limit.

But before that you need to figure out how many of them are...

Any clue why do i have two plans?

I need to check but could there...

Not sure what do you mean. I have attached...

GilaMonster (1/21/2011)

---

One and only one. A procedure can only have one plan in cache at a...

Eric M Russell (1/28/2011)

---

sqldba_icon (1/25/2011)

---

I am trying to findout is there a specific figure which would specify the % of cache being allocated from the memory. i did total of...

Mike - CI (1/27/2011)

---

Using SQLCLR would be a situation where you would have some .Net code that created a connection that you could dynamically pass into a function or proc...