DBADave (12/29/2008)

---

My 32-bit cluster is running 2005 SP1 and my 64-bit cluster is running 2005 SP2. Both are Enterprise Edition. We plan on calling Microsoft in January to...

DBADave (12/29/2008)

---

I'm having the same problem and can't find the cause. It started this month on two of our SQL clusters. One cluster is 32-bit and the...

Yeah, probably the ghost of Christmas past... 😉

Hopefully it's a one-of...

No, there is nothing in the .2 log or SQL...

Funny thing is, there is no...

Jonathan Kehayias (12/23/2008)

---

It won't be a leak. When a backup is running, query the sys.dm_exec_requests DMV and find the session_id that it is running on. Then query the...

Jonathan Kehayias (12/23/2008)

---

Watch your Error Log for the next few weeks and see if you experience App Domain Unloads due to memory pressure. If you get one or two...

Is a server reboot necessary after the -g384 parameter is added, or is an instance restart sufficient for the change to take effect?

Jonathan Kehayias (12/22/2008)

---

My numbers in testing seem to line up with what you are seeing. Change the last query out to be:

SELECT

CAST(Size AS BIGINT)/1024 AS [Free size, KB]...

Here is also a related question that I missed asking in my OP.

The -g384 parameter had an effect only on the Total avail mem, KB value and not the Max...

Jonathan Kehayias (12/22/2008)

---

You really need to goto x64. I can certainly understand that might not be an option, but for what you are trying to do x64 is so...

Jonathan, thanks for the response, I was hoping you would! 🙂

In my environment we have 8 GB of RAM (32-bit OS).

3-gb and PAE switches enabled.

2 SQL db-engine instances and...

CozyRoc (12/19/2008)

---

There is no place where you specify global limit for SSIS processes. You control memory consumption granulary, by controlling specific SSIS tasks memory constraints. A good example is the...

CozyRoc (12/19/2008)

---

This is unusual question, Marios. Why would you want to know how much memory is consumed by the SSIS service? Do you have an issue in particular?

I don't think...

Clustered indexes are best on columns used in the GROUP BY/ORDER BY part of queries, and/or if the column in question is used to retrieve a range of values.

Non-clustered indexes...