 | |
SQL 2005 SP2 Memory
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#101
 
| |||
| |||
|
Re: SQL 2005 SP2 Memory -
11-21-2008
, 02:00 PM
|
Perhaps you set up the log file trace incorrectly. Have you tried just doing a trace and not saving it? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "dfeldman" <dfeldman (AT) discussions (DOT) microsoft.com> wrote in message news:0E1F86D6-F240-4A23-867E-1D2E35FB2D1E (AT) microsoft (DOT) com... Next issue. When I try and open the log file to look at it does not show the sql counter just the standard ones but they are selected in the perfmon job "dfeldman" wrote: That worked. I will add those and report back. Thanks "Tom Moreau" wrote: There should be objects beginning with MSSQL$. Try starting perfmon in 32 bit mode: perfmon /32 -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "dfeldman" <dfeldman (AT) discussions (DOT) microsoft.com> wrote in message news:0F314D25-BCC7-4CE3-9810-2A967CF819B6 (AT) microsoft (DOT) com... I cannot find SQLServer as a choice in perfmon SQLServer:Buffer Manager - Buffer cache hit ratio SQLServer:Buffer Manager - Page life expectancy SQLServer:General Statistics - User Connections SQLServer:Memory Manager - Memory Grants Pending What am I missing? "Tom Moreau" wrote: You want the actual SQL Server Memory Manager object for that instance. For example, for the SQL2005 instance on the MYSERVER (MYSERVER\SQL2005), you want the following Computer, Object, Counter: MYSERVER MSSQL$SQL2005:Memory Manager Total Server Memory (KB) -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "dfeldman" <dfeldman (AT) discussions (DOT) microsoft.com> wrote in message news:05A63A81-EB59-431D-946F-C75E3A7C5860 (AT) microsoft (DOT) com... Yes, AWE is enabled for each instance. How do I tell in Perf mon which SQL Instance is what #. It shows sqlservr 1-6 "Tom Moreau" wrote: Are you using AWE? What does Total Server Memory say for each of the instances in Perf Mon? -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau "dfeldman" <dfeldman (AT) discussions (DOT) microsoft.com> wrote in message news:F1B5D8D4-6829-43F0-8AEA-3E8D666F8EA3 (AT) microsoft (DOT) com... I have a two server cluster with 32GB mem. I have six SQL instances running with the default memory settings. Min mem 0 Max all. When I look at Taskmanager process tab I see the six sqlserver.exe's and the most any are using is 250mb. Butr when i look at the perfromance tab it tells me that only 400mb of 32gb are free. Where is all the mem being used. Page file was originally set to 4gb. Reset to min 25gb max 60gb One strange thing is that after reboot for the pagefile change I cannot delete the old page file because it says it is in use but I verified the settings and there is not page file set for C. I moved to B and that partion shows a page file. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.