What we do get in the log file.. from time to time (including before the lock-ups)

Date4/26/2012 5:42:29 AM

LogSQL Server (Archive #1 - 4/26/2012 5:42:00 AM)

Sourcespid4s

Message

CACHESTORE_BROKERTO (Total)

VM Reserved = 0...

My boss states that he has always seen that you have to set the SQL server to Max RAM.. does anyone know of any links from MS (MSDN) that state...

I did have a trace running... but no data was written out.. I do not want to create large trace files, so if this keeps going on, I might get...

MS Server 2003 Standard x64 (Version 5.2.3790)

Microsoft SQL Server 2005 - 9.00.4060.00 (X64) Mar 17 2011 13:06:52 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)...

Interesting.. thanks.

Great! Thanks for the Help!

David

Let me guess.. given the result.. zero? Yep... knew it was simple, thanks.

Ok, Thanks!

BTW I get that same list, no matter where in the chart I right click on.

I am talking about the Y-Axis ... I have a count of issues and the the Sum of Volume in KG.. so if you put the two data elements together,...

What do you do when you have a dataset that several items are using, and you want one of the tables to only show the top 20 detail records?

Hey, thanks for the help.. yep that works. I wish it had given me a better error message.. so that I had known it was not like a case statement.....

Thanks for your help... still waiting for the meeting with management about this project, I will plan to try and use SSRS through our .NET dashboard.

I still have not been able to talk to my boss about this.. except in passing. I still think that he is over doing the shrinking of log files. The...

They are using the Backup command.. but backing up to file, instead of tape. I have restored two of their backup's and they are fine... so I do not know...