Whats the easy way to check for memory pressure to SQL or if its time to add
more RAM or if theres a memory leak
Its easy from a CPU or disk perspective to look at processor % or queue
length to atleast judge there is some bottleneck, but I have been very
uncertain about how to troubleshoot memory and get to know instantly there
is memory problems
ThanksAre you having performance issues? Is the server failing to run batches or
jobs or are you just trying to avert a fire?
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to a
dd
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
>
>|||You may want to refer to the following paper. Though it is SQL2005 centric
but is useful for SQL2000 too.
http://download.microsoft.com/downl...otPerfProbs.doc
thanks,
--
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:54C8BF2A-CD55-46ED-90D7-C0431A9D51B0@.microsoft.com...[vbcol=seagreen]
> Are you having performance issues? Is the server failing to run batches
> or
> jobs or are you just trying to avert a fire?
> "Hassan" wrote:
>|||Following links have some useful information:
1. Monitoring Memory Usage at
http://msdn.microsoft.com/library/d.../>
on_8x0l.asp
2. Identifying Bottlenecks and Performance-Tuning SQL Server
http://www.informit.com/articles/ar...5&seqNum=2&rl=1
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to a
dd
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
Showing posts with label cpu. Show all posts
Showing posts with label cpu. Show all posts
Sunday, March 25, 2012
check memory pressure
Whats the easy way to check for memory pressure to SQL or if its time to add
more RAM or if theres a memory leak
Its easy from a CPU or disk perspective to look at processor % or queue
length to atleast judge there is some bottleneck, but I have been very
uncertain about how to troubleshoot memory and get to know instantly there
is memory problems
Thanks
Are you having performance issues? Is the server failing to run batches or
jobs or are you just trying to avert a fire?
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
>
>
|||You may want to refer to the following paper. Though it is SQL2005 centric
but is useful for SQL2000 too.
http://download.microsoft.com/downlo...tPerfProbs.doc
thanks,
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:54C8BF2A-CD55-46ED-90D7-C0431A9D51B0@.microsoft.com...[vbcol=seagreen]
> Are you having performance issues? Is the server failing to run batches
> or
> jobs or are you just trying to avert a fire?
> "Hassan" wrote:
|||Following links have some useful information:
1. Monitoring Memory Usage at
http://msdn.microsoft.com/library/de...rfmon_8x0l.asp
2. Identifying Bottlenecks and Performance-Tuning SQL Server
http://www.informit.com/articles/art...&seqNum=2&rl=1
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
more RAM or if theres a memory leak
Its easy from a CPU or disk perspective to look at processor % or queue
length to atleast judge there is some bottleneck, but I have been very
uncertain about how to troubleshoot memory and get to know instantly there
is memory problems
Thanks
Are you having performance issues? Is the server failing to run batches or
jobs or are you just trying to avert a fire?
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
>
>
|||You may want to refer to the following paper. Though it is SQL2005 centric
but is useful for SQL2000 too.
http://download.microsoft.com/downlo...tPerfProbs.doc
thanks,
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:54C8BF2A-CD55-46ED-90D7-C0431A9D51B0@.microsoft.com...[vbcol=seagreen]
> Are you having performance issues? Is the server failing to run batches
> or
> jobs or are you just trying to avert a fire?
> "Hassan" wrote:
|||Following links have some useful information:
1. Monitoring Memory Usage at
http://msdn.microsoft.com/library/de...rfmon_8x0l.asp
2. Identifying Bottlenecks and Performance-Tuning SQL Server
http://www.informit.com/articles/art...&seqNum=2&rl=1
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
check memory pressure
Whats the easy way to check for memory pressure to SQL or if its time to add
more RAM or if theres a memory leak
Its easy from a CPU or disk perspective to look at processor % or queue
length to atleast judge there is some bottleneck, but I have been very
uncertain about how to troubleshoot memory and get to know instantly there
is memory problems
ThanksAre you having performance issues? Is the server failing to run batches or
jobs or are you just trying to avert a fire?
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
>
>|||You may want to refer to the following paper. Though it is SQL2005 centric
but is useful for SQL2000 too.
http://download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/TShootPerfProbs.doc
thanks,
--
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:54C8BF2A-CD55-46ED-90D7-C0431A9D51B0@.microsoft.com...
> Are you having performance issues? Is the server failing to run batches
> or
> jobs or are you just trying to avert a fire?
> "Hassan" wrote:
>> Whats the easy way to check for memory pressure to SQL or if its time to
>> add
>> more RAM or if theres a memory leak
>> Its easy from a CPU or disk perspective to look at processor % or queue
>> length to atleast judge there is some bottleneck, but I have been very
>> uncertain about how to troubleshoot memory and get to know instantly
>> there
>> is memory problems
>> Thanks
>>|||Following links have some useful information:
1. Monitoring Memory Usage at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_8x0l.asp
2. Identifying Bottlenecks and Performance-Tuning SQL Server
http://www.informit.com/articles/article.asp?p=390585&seqNum=2&rl=1
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thankssql
more RAM or if theres a memory leak
Its easy from a CPU or disk perspective to look at processor % or queue
length to atleast judge there is some bottleneck, but I have been very
uncertain about how to troubleshoot memory and get to know instantly there
is memory problems
ThanksAre you having performance issues? Is the server failing to run batches or
jobs or are you just trying to avert a fire?
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thanks
>
>|||You may want to refer to the following paper. Though it is SQL2005 centric
but is useful for SQL2000 too.
http://download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/TShootPerfProbs.doc
thanks,
--
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"fnguy" <fnguy@.discussions.microsoft.com> wrote in message
news:54C8BF2A-CD55-46ED-90D7-C0431A9D51B0@.microsoft.com...
> Are you having performance issues? Is the server failing to run batches
> or
> jobs or are you just trying to avert a fire?
> "Hassan" wrote:
>> Whats the easy way to check for memory pressure to SQL or if its time to
>> add
>> more RAM or if theres a memory leak
>> Its easy from a CPU or disk perspective to look at processor % or queue
>> length to atleast judge there is some bottleneck, but I have been very
>> uncertain about how to troubleshoot memory and get to know instantly
>> there
>> is memory problems
>> Thanks
>>|||Following links have some useful information:
1. Monitoring Memory Usage at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_8x0l.asp
2. Identifying Bottlenecks and Performance-Tuning SQL Server
http://www.informit.com/articles/article.asp?p=390585&seqNum=2&rl=1
"Hassan" wrote:
> Whats the easy way to check for memory pressure to SQL or if its time to add
> more RAM or if theres a memory leak
> Its easy from a CPU or disk perspective to look at processor % or queue
> length to atleast judge there is some bottleneck, but I have been very
> uncertain about how to troubleshoot memory and get to know instantly there
> is memory problems
> Thankssql
Wednesday, March 7, 2012
Check all CPU's are used
We added a new CPU to our 1 CPU box making it a 2 CPU box.
In order to check that Sql is using both CPU's, I'm going
to load 2 bcp files simultaneously. I'll check the task
manager to monitor that CPU usage increases for both CPU's.
Is there a better way to show my sysadmin that both CPU's
are being used ? He refuses to believe that SQL will
recognize both CPU's without a reconfiguration.
TIA,
JackIn Enterprise Manager, right-click the server name, select properties and
click the processor tab. Check the CPUs you want to use. You may need to
stop and restart the services...can't remember.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
No need to do a configuration change to use the second CPU.
How to check is.
1. Use the Performance monitor from Control panel ...Admin tools
2. From the conter, u have to select Processor and select the 2 CPUs
seperately.
3. Now you run your SQL server batch processes.
This will give you a picture of CPU usage.
Thanks
Hari
MCDBA
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
In order to check that Sql is using both CPU's, I'm going
to load 2 bcp files simultaneously. I'll check the task
manager to monitor that CPU usage increases for both CPU's.
Is there a better way to show my sysadmin that both CPU's
are being used ? He refuses to believe that SQL will
recognize both CPU's without a reconfiguration.
TIA,
JackIn Enterprise Manager, right-click the server name, select properties and
click the processor tab. Check the CPUs you want to use. You may need to
stop and restart the services...can't remember.
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
quote:|||Hi,
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack
No need to do a configuration change to use the second CPU.
How to check is.
1. Use the Performance monitor from Control panel ...Admin tools
2. From the conter, u have to select Processor and select the 2 CPUs
seperately.
3. Now you run your SQL server batch processes.
This will give you a picture of CPU usage.
Thanks
Hari
MCDBA
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
quote:
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack
Check all CPU's are used
We added a new CPU to our 1 CPU box making it a 2 CPU box.
In order to check that Sql is using both CPU's, I'm going
to load 2 bcp files simultaneously. I'll check the task
manager to monitor that CPU usage increases for both CPU's.
Is there a better way to show my sysadmin that both CPU's
are being used ? He refuses to believe that SQL will
recognize both CPU's without a reconfiguration.
TIA,
JackIn Enterprise Manager, right-click the server name, select properties and
click the processor tab. Check the CPUs you want to use. You may need to
stop and restart the services...can't remember.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack|||Hi,
No need to do a configuration change to use the second CPU.
How to check is.
1. Use the Performance monitor from Control panel ...Admin tools
2. From the conter, u have to select Processor and select the 2 CPUs
seperately.
3. Now you run your SQL server batch processes.
This will give you a picture of CPU usage.
Thanks
Hari
MCDBA
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack
In order to check that Sql is using both CPU's, I'm going
to load 2 bcp files simultaneously. I'll check the task
manager to monitor that CPU usage increases for both CPU's.
Is there a better way to show my sysadmin that both CPU's
are being used ? He refuses to believe that SQL will
recognize both CPU's without a reconfiguration.
TIA,
JackIn Enterprise Manager, right-click the server name, select properties and
click the processor tab. Check the CPUs you want to use. You may need to
stop and restart the services...can't remember.
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack|||Hi,
No need to do a configuration change to use the second CPU.
How to check is.
1. Use the Performance monitor from Control panel ...Admin tools
2. From the conter, u have to select Processor and select the 2 CPUs
seperately.
3. Now you run your SQL server batch processes.
This will give you a picture of CPU usage.
Thanks
Hari
MCDBA
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:64f501c3e69d$d53d1570$a301280a@.phx.gbl...
> We added a new CPU to our 1 CPU box making it a 2 CPU box.
> In order to check that Sql is using both CPU's, I'm going
> to load 2 bcp files simultaneously. I'll check the task
> manager to monitor that CPU usage increases for both CPU's.
> Is there a better way to show my sysadmin that both CPU's
> are being used ? He refuses to believe that SQL will
> recognize both CPU's without a reconfiguration.
> TIA,
> Jack
Subscribe to:
Posts (Atom)