coastliner (5/13/2008)

---

What I need is to have the possibility to schedule backups...so I left active the SQL server Agent. Stop.

BTW I was always told of a 4GB limit on 32bit...

If you had AWE enabled, then it's no different than sql 2000.

Thanks for clarifying.

Unless you enabled AWE, that's mathematically impossible.

The 32-bit address space simply does not have the capacity to reach that kind of memory...

As Steve mentioned, it looks like long transactions are the main culprit here.

It may also be that the SQL code in your instance needs tuning.

Internal objects generated during query processing...

jim.powers (5/13/2008)

---

I had a SQL Server with my previous employer that had 16GB of RAM installed using AWE. I had SQL Server setup to use a max of 14GB and...

coastliner (5/13/2008)

---

I monitored with sysinternal Process Explorer and discovered that , apart the Main SQL Service, the other does not take as much memory, and I think I could disable...

Animal Magic (5/13/2008)

---

Coastliner, are you actually using all the services? or have they been installed by someone who clicked every available option on the install and then just left...

coastliner (5/13/2008)

---

Please let me understend or I'll go nuts!!! The Default Memory for the server is set to 2147483647 (MB) right ??.

Does it mean over 2 Billion...

I have managed to replicate SQLCLR objects using an SSIS package. A config table on the central db containing the SQLCLR objects is populated with the server instances and local...

Aaron Nelson (5/12/2008)

---

I'll just say that my experience was pretty positive.

It didn't eat up much CPU or I/O for us and virtually completely cleaned up our blocking issues.

I hoped that...

I had the exact same issue yesterday. 🙂

Run the following. I bet your schema is not "dbo".

Owner is probably not dbo.

What is the owner/schema of the table?

george sibbald (5/9/2008)

---

Marios,

I think your mistake was physically moving the tempdb files manually. Just ensure the new directory structure exists (actually if they don't alter database will fail), run alter...

TheSQLGuru (5/9/2008)

---

Marios Philippopoulos (5/8/2008)

---

I'm also experiencing difficulties convincing our SAN people that RAID 5 is unacceptable, especially for tempdb.

Also tempdb data files need to be on their own dedicated physical...

Microsoft best practices dictate that tempdb data files be made of equal size, on no autogrowth, in a separate physical device from other files. Also there should be (roughly) as...