465789psw (11/5/2009)

---

Sorry I didnt word it right, but your note is a memory dump, the os ran out of memory. on our cluster environment is caused our primary server to...

465789psw (11/5/2009)

---

also one other note it very possible that the memory dropped, if you do not have a max memory setting set sql will and can page memory out.. as...

jagadeesanpv (11/4/2009)

---

webrunner (11/4/2009)

---

Hello,

We have a SQL 2005 64-bit (SP2) SQL Server where the Minimum server memory (in MB) is set to 10240 MB.

But in Task Manager, when I just checked,...

Thanks for this additional advice!

-webrunner

Thanks for the replies.

I think I'm leaning towards installing SP2 on the test server, since (to complicate things even more) we are moving from SQL 2000 to 2005 and the...

Steve Jones - Editor (10/20/2009)

---

I would think this is the DDL to create a procedure. If it's suspended, maybe the network link got shattered and SQL didn't close it out...

Thanks again - that did the trick!

webrunner

Many thanks - I will check it out.

webrunner

Adi Cohn-120898 (9/24/2009)

---

I’m not sure that the schema locks cause blocking. As far as I know schema locks won’t let you modify the table’s structure but it doesn’t block...

Thanks for your replies.

Based on your information and on what we know so far, it does seem like the rebooting of the web servers may have released locks that were...

Great question. I couldn't believe that such a wacked-out query would work.

webrunner

Thanks - that's interesting. When I check the history for...

465789psw (9/21/2009)

---

did you check in the error log in order to make sure an alert was written to the the log? looks like your setting are right.

I am assuming...

Ouch is right. 🙂 I got the fact that the LEN ignores the last...

Steve Jones - Editor (8/31/2009)

---

If you want to simulate more real time work, add a waitfor() inside the transaction for a random delay and then commit the transaction. Wrap that...