Viewing 15 posts - 346 through 360 (of 496 total)
quote:
Have you verified that the server "linkage" is actually working? After you create the link, can you select the linked server...
November 20, 2003 at 5:53 am
Some bad news for current MCDBA: you will not upgrade by passing one or two exams anymore...
November 12, 2003 at 12:03 am
One of my collegs found disk performance statistics, that showed that 32KB sripe size is the best for MS SQL 6.5, so, as he said, the same should be for...
November 6, 2003 at 7:02 am
This is the version I have:
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195:...
November 6, 2003 at 5:45 am
The few last messages in "Perf. counters not affected by memory encrease" topic, in "Performance Tuning" forum. I could not edit them right after I posted them, but now,...
October 30, 2003 at 12:36 am
[/quote]
Again, I do not find this unusual in the least. Unless you can guarantee that the entire application environment (data, queries performed, etc.) is exactly the same as before,...
October 29, 2003 at 8:39 am
quote:
Which cache hit ratio are you referring to, from cache manager objects or buffer manager objetcs in performance monitor?
October 29, 2003 at 8:30 am
quote:
Nothing unusual here, then. Due to all available memory being used for data caching, the lazywriter is aging out query plans,...
October 29, 2003 at 7:55 am
Just to notice:
I have a -T2861 flag turned on, that does not allow to flush out of cache zero-cost plans.
October 29, 2003 at 7:43 am
quote:
Nothing unusual here, then. Due to all available memory being used for data caching, the lazywriter is aging out query plans,...
October 29, 2003 at 7:36 am
2Jonathan:
quote:
This is correct and could be relevant. The procedure cache is limited to the buffer pool space in the non-AWE (below...
October 29, 2003 at 3:53 am
2Allen_Cui:
quote:
How much memory SQL Server uses from Task Manager? Task manager wouldn't give your accurate information about how much memory processes use...
October 29, 2003 at 3:50 am
2Antares686:
quote:
Regardless you should see an increase to I would suggest right at 100% with that much more RAM.
October 29, 2003 at 3:31 am
quote:
If you're performing more query plan compilations now, then your cache Hit Ratio would of course decrease; this would be normal after...
October 28, 2003 at 12:31 am
I have AWE enabled for MS SQL, also I have /PAE and 3G switches in boot.ini.
Max/Min Server Memory are both set to 15700.
Task manager does not show correct memory usage...
October 26, 2003 at 1:38 am
Viewing 15 posts - 346 through 360 (of 496 total)