 | |
#41
 
| |||
| |||
|
Re: SQL 2005 SP2 Memory -
11-20-2008
, 09:02 AM
|
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. |
#42
| |||
| |||
|
|
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. |
#43
| |||
| |||
|
|
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. |
#44
| |||
| |||
|
|
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. |
#45
| |||
| |||
|
|
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. |
#46
| |||
| |||
|
|
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. |
#47
| |||
| |||
|
|
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. |
#48
| |||
| |||
|
|
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. |
#49
| |||
| |||
|
|
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. |
#50
| |||
| |||
|
|
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.