Intermittent Slowdown Of SQL Server 2000

Hi,
I have been struggling to identify the cause of an application go slow
that happens perhaps once a month or a day or two after the server has
been rebooted. The application is a web based ASP app that uses SQL
server 2000, both on the same box. This has been occuring for at least
6 months, probably longer and the only way I have found to overcome
this problem without a server reboot is to restart to the SQL service.

>From my investigations I am assuming that the problem is SQL server
related but I am unable to identify the root cause of the problem and
was wondering if anyone can offer suggestions to help me fix this
issue.
Many Thanks
This sounds like this is a blocking problem. You can try to identify
the blocking SPID. If you run this SQL Statement, you'll get the heads
for the blocking chain:
select blocker.spid
from master..sysprocesses blocker inner join master..sysprocesses
blocked
on blocker.spid = blocked.blocked
where blocker.blocked = 0
After you get the blocking spid you can chek what the process is doing
and who is running it with sp_who2 and dbcc inputbuffer.
Adi
Ham wrote:
> Hi,
> I have been struggling to identify the cause of an application go slow
> that happens perhaps once a month or a day or two after the server has
> been rebooted. The application is a web based ASP app that uses SQL
> server 2000, both on the same box. This has been occuring for at least
> 6 months, probably longer and the only way I have found to overcome
> this problem without a server reboot is to restart to the SQL service.
> related but I am unable to identify the root cause of the problem and
> was wondering if anyone can offer suggestions to help me fix this
> issue.
> Many Thanks
|||Hi,
Try using fixed memory area for SQL Server.
Also to start with basics
Use SQL Profiler to capture the events at that time.
Thanks
Ajay
Adi wrote:[vbcol=seagreen]
> This sounds like this is a blocking problem. You can try to identify
> the blocking SPID. If you run this SQL Statement, you'll get the heads
> for the blocking chain:
> select blocker.spid
> from master..sysprocesses blocker inner join master..sysprocesses
> blocked
> on blocker.spid = blocked.blocked
> where blocker.blocked = 0
> After you get the blocking spid you can chek what the process is doing
> and who is running it with sp_who2 and dbcc inputbuffer.
> Adi
> Ham wrote:
|||Thanks all, I will try these when the problem next occurs.
Thanks Again
On 23 Jan, 10:50, "Adi" <adic...@.hotmail.com> wrote:[vbcol=seagreen]
> This sounds like this is a blocking problem. You can try to identify
> the blocking SPID. If you run thisSQLStatement, you'll get the heads
> for the blocking chain:
> select blocker.spid
> from master..sysprocesses blocker inner join master..sysprocesses
> blocked
> on blocker.spid = blocked.blocked
> where blocker.blocked = 0
> After you get the blocking spid you can chek what the process is doing
> and who is running it with sp_who2 and dbcc inputbuffer.
> Adi
>
> Ham wrote:
>
sql

Intermittent Slowdown Of SQL Server 2000

Hi,
I have been struggling to identify the cause of an application go slow
that happens perhaps once a month or a day or two after the server has
been rebooted. The application is a web based ASP app that uses SQL
server 2000, both on the same box. This has been occuring for at least
6 months, probably longer and the only way I have found to overcome
this problem without a server reboot is to restart to the SQL service.
>From my investigations I am assuming that the problem is SQL server
related but I am unable to identify the root cause of the problem and
was wondering if anyone can offer suggestions to help me fix this
issue.
Many ThanksThis sounds like this is a blocking problem. You can try to identify
the blocking SPID. If you run this SQL Statement, you'll get the heads
for the blocking chain:
select blocker.spid
from master..sysprocesses blocker inner join master..sysprocesses
blocked
on blocker.spid = blocked.blocked
where blocker.blocked = 0
After you get the blocking spid you can chek what the process is doing
and who is running it with sp_who2 and dbcc inputbuffer.
Adi
Ham wrote:
> Hi,
> I have been struggling to identify the cause of an application go slow
> that happens perhaps once a month or a day or two after the server has
> been rebooted. The application is a web based ASP app that uses SQL
> server 2000, both on the same box. This has been occuring for at least
> 6 months, probably longer and the only way I have found to overcome
> this problem without a server reboot is to restart to the SQL service.
> >From my investigations I am assuming that the problem is SQL server
> related but I am unable to identify the root cause of the problem and
> was wondering if anyone can offer suggestions to help me fix this
> issue.
> Many Thanks|||Hi,
Try using fixed memory area for SQL Server.
Also to start with basics
Use SQL Profiler to capture the events at that time.
Thanks
Ajay
Adi wrote:
> This sounds like this is a blocking problem. You can try to identify
> the blocking SPID. If you run this SQL Statement, you'll get the heads
> for the blocking chain:
> select blocker.spid
> from master..sysprocesses blocker inner join master..sysprocesses
> blocked
> on blocker.spid = blocked.blocked
> where blocker.blocked = 0
> After you get the blocking spid you can chek what the process is doing
> and who is running it with sp_who2 and dbcc inputbuffer.
> Adi
> Ham wrote:
> > Hi,
> >
> > I have been struggling to identify the cause of an application go slow
> > that happens perhaps once a month or a day or two after the server has
> > been rebooted. The application is a web based ASP app that uses SQL
> > server 2000, both on the same box. This has been occuring for at least
> > 6 months, probably longer and the only way I have found to overcome
> > this problem without a server reboot is to restart to the SQL service.
> >
> > >From my investigations I am assuming that the problem is SQL server
> > related but I am unable to identify the root cause of the problem and
> > was wondering if anyone can offer suggestions to help me fix this
> > issue.
> >
> > Many Thanks|||Thanks all, I will try these when the problem next occurs.
Thanks Again
On 23 Jan, 10:50, "Adi" <adic...@.hotmail.com> wrote:
> This sounds like this is a blocking problem. You can try to identify
> the blocking SPID. If you run thisSQLStatement, you'll get the heads
> for the blocking chain:
> select blocker.spid
> from master..sysprocesses blocker inner join master..sysprocesses
> blocked
> on blocker.spid = blocked.blocked
> where blocker.blocked = 0
> After you get the blocking spid you can chek what the process is doing
> and who is running it with sp_who2 and dbcc inputbuffer.
> Adi
>
> Ham wrote:
> > Hi,
> > I have been struggling to identify the cause of an application go slow
> > that happens perhaps once a month or a day or two after the server has
> > been rebooted. The application is a web based ASP app that usesSQL
> > server 2000, both on the same box. This has been occuring for at least
> > 6 months, probably longer and the only way I have found to overcome
> > this problem without a server reboot is to restart to theSQLservice.
> > >From my investigations I am assuming that the problem isSQLserver
> > related but I am unable to identify the root cause of the problem and
> > was wondering if anyone can offer suggestions to help me fix this
> > issue.
> > Many Thanks- Hide quoted text -- Show quoted text -

Intermittent Slowdown Of SQL Server 2000

Hi,
I have been struggling to identify the cause of an application go slow
that happens perhaps once a month or a day or two after the server has
been rebooted. The application is a web based ASP app that uses SQL
server 2000, both on the same box. This has been occuring for at least
6 months, probably longer and the only way I have found to overcome
this problem without a server reboot is to restart to the SQL service.

>From my investigations I am assuming that the problem is SQL server
related but I am unable to identify the root cause of the problem and
was wondering if anyone can offer suggestions to help me fix this
issue.
Many ThanksThis sounds like this is a blocking problem. You can try to identify
the blocking SPID. If you run this SQL Statement, you'll get the heads
for the blocking chain:
select blocker.spid
from master..sysprocesses blocker inner join master..sysprocesses
blocked
on blocker.spid = blocked.blocked
where blocker.blocked = 0
After you get the blocking spid you can chek what the process is doing
and who is running it with sp_who2 and dbcc inputbuffer.
Adi
Ham wrote:
> Hi,
> I have been struggling to identify the cause of an application go slow
> that happens perhaps once a month or a day or two after the server has
> been rebooted. The application is a web based ASP app that uses SQL
> server 2000, both on the same box. This has been occuring for at least
> 6 months, probably longer and the only way I have found to overcome
> this problem without a server reboot is to restart to the SQL service.
>
> related but I am unable to identify the root cause of the problem and
> was wondering if anyone can offer suggestions to help me fix this
> issue.
> Many Thanks|||Hi,
Try using fixed memory area for SQL Server.
Also to start with basics
Use SQL Profiler to capture the events at that time.
Thanks
Ajay
Adi wrote:[vbcol=seagreen]
> This sounds like this is a blocking problem. You can try to identify
> the blocking SPID. If you run this SQL Statement, you'll get the heads
> for the blocking chain:
> select blocker.spid
> from master..sysprocesses blocker inner join master..sysprocesses
> blocked
> on blocker.spid = blocked.blocked
> where blocker.blocked = 0
> After you get the blocking spid you can chek what the process is doing
> and who is running it with sp_who2 and dbcc inputbuffer.
> Adi
> Ham wrote:|||Thanks all, I will try these when the problem next occurs.
Thanks Again
On 23 Jan, 10:50, "Adi" <adic...@.hotmail.com> wrote:[vbcol=seagreen]
> This sounds like this is a blocking problem. You can try to identify
> the blocking SPID. If you run thisSQLStatement, you'll get the heads
> for the blocking chain:
> select blocker.spid
> from master..sysprocesses blocker inner join master..sysprocesses
> blocked
> on blocker.spid = blocked.blocked
> where blocker.blocked = 0
> After you get the blocking spid you can chek what the process is doing
> and who is running it with sp_who2 and dbcc inputbuffer.
> Adi
>
> Ham wrote:
>
>
>

Intel processor identifier tool, where is it?

Hi,
I have lost the link where there is a tool to identify the processors in my
server.
to identify which one is the physical and which one is the HT.
any one can help me?
thanks.
Jerome.
Hi
On a box with 4 HT physical processors, Windows looks at them as follows:
0,1 2,3 are the 1st 'processor' on a chip
4,5,6,7 are the 2nd 'processor' on a chip.
So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>
|||thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>
|||http://www.intel.com/cd/ids/develope...logy/19122.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>
|||thanks !
finally my physical processors are the 0,2,4&6
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObfPWET7FHA.2692@.tk2msftngp13.phx.gbl...
> http://www.intel.com/cd/ids/develope...logy/19122.htm
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>
|||Actually Mike I believe it depends on the motherboard as to the order. Some
are 0123 and others are 0,2,4,6.
Andrew J. Kelly SQL MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>

Intel processor identifier tool, where is it?

Hi,
I have lost the link where there is a tool to identify the processors in my
server.
to identify which one is the physical and which one is the HT.
any one can help me?
thanks.
Jerome.Hi
On a box with 4 HT physical processors, Windows looks at them as follows:
0,1 2,3 are the 1st 'processor' on a chip
4,5,6,7 are the 2nd 'processor' on a chip.
So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>|||thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>|||http://www.intel.com/cd/ids/develop...122.h
tm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>|||thanks !
finally my physical processors are the 0,2,4&6
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObfPWET7FHA.2692@.tk2msftngp13.phx.gbl...
> http://www.intel.com/cd/ids/develop...122
.htm
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>|||Actually Mike I believe it depends on the motherboard as to the order. Some
are 0123 and others are 0,2,4,6.
Andrew J. Kelly SQL MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>

Intel processor identifier tool, where is it?

Hi,
I have lost the link where there is a tool to identify the processors in my
server.
to identify which one is the physical and which one is the HT.
any one can help me?
thanks.
Jerome.Hi
On a box with 4 HT physical processors, Windows looks at them as follows:
0,1 2,3 are the 1st 'processor' on a chip
4,5,6,7 are the 2nd 'processor' on a chip.
So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>|||thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have lost the link where there is a tool to identify the processors in
>> my server.
>> to identify which one is the physical and which one is the HT.
>> any one can help me?
>> thanks.
>> Jerome.
>>
>|||http://www.intel.com/cd/ids/developer/asmo-na/eng/dc/threading/methodology/19122.htm
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>|||thanks !
finally my physical processors are the 0,2,4&6
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObfPWET7FHA.2692@.tk2msftngp13.phx.gbl...
> http://www.intel.com/cd/ids/developer/asmo-na/eng/dc/threading/methodology/19122.htm
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have lost the link where there is a tool to identify the processors in
>> my server.
>> to identify which one is the physical and which one is the HT.
>> any one can help me?
>> thanks.
>> Jerome.
>>
>|||Actually Mike I believe it depends on the motherboard as to the order. Some
are 0123 and others are 0,2,4,6.
--
Andrew J. Kelly SQL MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> I have lost the link where there is a tool to identify the processors in
>> my server.
>> to identify which one is the physical and which one is the HT.
>> any one can help me?
>> thanks.
>> Jerome.
>>
>

Intel processor identifier tool, where is it?

Hi,
I have lost the link where there is a tool to identify the processors in my
server.
to identify which one is the physical and which one is the HT.
any one can help me?
thanks.
Jerome.
Hi
On a box with 4 HT physical processors, Windows looks at them as follows:
0,1 2,3 are the 1st 'processor' on a chip
4,5,6,7 are the 2nd 'processor' on a chip.
So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>
|||thanks.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>
|||http://www.intel.com/cd/ids/develope...logy/19122.htm
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have lost the link where there is a tool to identify the processors in
> my server.
> to identify which one is the physical and which one is the HT.
> any one can help me?
> thanks.
> Jerome.
>
|||thanks !
finally my physical processors are the 0,2,4&6
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:ObfPWET7FHA.2692@.tk2msftngp13.phx.gbl...
> http://www.intel.com/cd/ids/develope...logy/19122.htm
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>
|||Actually Mike I believe it depends on the motherboard as to the order. Some
are 0123 and others are 0,2,4,6.
Andrew J. Kelly SQL MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:e1BtuyQ7FHA.3984@.TK2MSFTNGP11.phx.gbl...
> Hi
> On a box with 4 HT physical processors, Windows looks at them as follows:
> 0,1 2,3 are the 1st 'processor' on a chip
> 4,5,6,7 are the 2nd 'processor' on a chip.
> So if you want SQL not to use the 2nd HT 'processor', don't enable 4,5,6,7
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:eHzD6y36FHA.1248@.TK2MSFTNGP14.phx.gbl...
>