opc.three (3/26/2012)

---

Brandie Tarvin (3/26/2012)

---

Opc, you do realize I'm not the OP, right?...

Opc, you do realize I'm not the OP, right? I only posted...

I don't have Kimberly's contact information to email her the updated proc.

As far as my results go, they're pretty nasty.

CacheType Total Plans Total MBs Avg Use Count Total MBs...

If you run into the overflow error, like I did, try this:

SELECT objtype AS [CacheType],

COUNT_BIG(*) AS [Total Plans],

...

I'm not the OP, but I decided to try it anyway. I think I'm scared of my result.

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to...

Glad we could help.

yonder

Memory experts needed, please. All my advice is based off of stuff I found on the 'net and not on real experiencing managing the memory.

http://www.sqlservercentral.com/Forums/Topic1271523-1550-1.aspx

Do you have a lot of ad hoc queries running in your system?

Do you have a lot of procs that recompile each time they run?

From what I understand, this could...

What did you tinker with? What...

ananda.murugesan (3/25/2012)

---

1. Could you tell me, In Memory Object counter - Total & Target memory shows same values and same memory. Does these values are good or bad?

2. Total 4GB...

Mhlewis (3/23/2012)

---

Brandie - this is an infrastructure upgrade. The only benefit is that once our server is upgraded to Windows Server 2008 it can be virtualized and then our...

hbtkp (3/23/2012)

---

the problem was in my stored proc, i called 2 stored proc that internally calling function, and i was joinin gthis two function by passing parameter,but my prob...

SQL Server is the software. So, too, is Oracle.

Data warehouses vary so much from...

Since you couldn't find the answer when you searched, could you post the solution that you used for someone else searching in the future?