Viewing 15 posts - 1 through 15 (of 224 total)
Like everyone else, I think I'm there on the CRUD stuff. Although, with some of our apps where the business logic is inherently deeply engrained with the data, I...
August 13, 2012 at 7:55 am
Chris Howarth-536003 (10/14/2009)
Have you managed...
October 15, 2009 at 7:43 am
Yes, lock pages all set. If memory serves that was part of enabling AWE.
Thanks. RH
October 15, 2009 at 7:40 am
Well, I can at least predict the behavior now. When my largest free memory block dropped below 4mb today, my server activity went wild. I checked the SQL...
October 14, 2009 at 12:59 pm
IIS is not installed. SSRS 2008 doesn't require it.
October 14, 2009 at 12:44 pm
Just following back up. I had let the server go for a while because service wasn't really being impacted in the environment and I was trying to get a...
October 12, 2009 at 12:20 pm
That is great info Chris, thanks. I will do that and report results back to this thread.
Thanks. RH
October 8, 2009 at 9:49 am
Chris Howarth-536003 (10/7/2009)
Thinking back there was actually another occasion when we experienced a similar problem...
October 8, 2009 at 6:34 am
Eoin (10/8/2009)
Try running the followingselect name, SUM(single_pages_kb + multi_pages_kb)/1024.0 MBUsed
from sys.dm_os_memory_clerks
group by name
order by 2 desc
with particular empasis on figures for Tokenandpermuserstore, sql plans and object plans
There were...
October 8, 2009 at 6:28 am
You had me excited...sounded like the ticket...just couldn't remember if we officially took the /3GB dive back when we enabled PAE and AWE. So, I checked my boot.ini and...
October 7, 2009 at 7:58 pm
It's all sqlserver.exe. This is a dedicated sql box with a couple SharePoint boxes (and other IIS boxes) connecting over the network.
Thanks. RH
October 6, 2009 at 6:26 am
Grant, service levels are currently being adhered to...no queries are excessively blocking...or being blocked. My user environment doesn't ever notice that CPU usage goes awry. Recall that the...
October 5, 2009 at 1:33 pm
Yes, I've considered that...let me bounce this off you. This server is Win2003 R2 32 bit Enterprise with 3GB switch and AWE enabled with 10GB RAM.
Two things I've found...
October 5, 2009 at 1:26 pm
Installed SP3 on a consolidated server last week. No issues.
October 5, 2009 at 11:09 am
Yeah, I think I'm going to back up the databases and pull a drive from the mirror...seems like the best approach.
Thanks. RH
September 28, 2009 at 2:48 pm
Viewing 15 posts - 1 through 15 (of 224 total)