I'd like to get a script/application that would peg all the CPUs. I just
want to do some load testing, but dont really know how to get my CPUs
pegged. Can someone help ?
I just want to max them out for like a couple of minutes.
And this should work on both 2000/2005
ThanksHi Hassan
Do you want to set the affinity mask using sp_configure? See
http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
John
"Hassan" wrote:
> I'd like to get a script/application that would peg all the CPUs. I just
> want to do some load testing, but dont really know how to get my CPUs
> pegged. Can someone help ?
> I just want to max them out for like a couple of minutes.
> And this should work on both 2000/2005
> Thanks
>
>|||No, I dont want to set the affinity mask. I just want to run a SQL that will
have my CPUs at 100% processor time.
This is for some testing..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...[vbcol=seagreen]
> Hi Hassan
> Do you want to set the affinity mask using sp_configure? See
> http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
> John
> "Hassan" wrote:
>|||Hi
I am not sure why SQL Server would have this inbuilt? Try dropping your
indexes and re-running a trace using multiple threads.
John
"Hassan" wrote:
> No, I dont want to set the affinity mask. I just want to run a SQL that wi
ll
> have my CPUs at 100% processor time.
> This is for some testing..
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...
>
>
Showing posts with label peg. Show all posts
Showing posts with label peg. Show all posts
Monday, March 26, 2012
Script to peg all CPUs
I'd like to get a script/application that would peg all the CPUs. I just
want to do some load testing, but dont really know how to get my CPUs
pegged. Can someone help ?
I just want to max them out for like a couple of minutes.
And this should work on both 2000/2005
Thanks
Hi Hassan
Do you want to set the affinity mask using sp_configure? See
http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
John
"Hassan" wrote:
> I'd like to get a script/application that would peg all the CPUs. I just
> want to do some load testing, but dont really know how to get my CPUs
> pegged. Can someone help ?
> I just want to max them out for like a couple of minutes.
> And this should work on both 2000/2005
> Thanks
>
>
|||No, I dont want to set the affinity mask. I just want to run a SQL that will
have my CPUs at 100% processor time.
This is for some testing..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...[vbcol=seagreen]
> Hi Hassan
> Do you want to set the affinity mask using sp_configure? See
> http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
> John
> "Hassan" wrote:
|||Hi
I am not sure why SQL Server would have this inbuilt? Try dropping your
indexes and re-running a trace using multiple threads.
John
"Hassan" wrote:
> No, I dont want to set the affinity mask. I just want to run a SQL that will
> have my CPUs at 100% processor time.
> This is for some testing..
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...
>
>
want to do some load testing, but dont really know how to get my CPUs
pegged. Can someone help ?
I just want to max them out for like a couple of minutes.
And this should work on both 2000/2005
Thanks
Hi Hassan
Do you want to set the affinity mask using sp_configure? See
http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
John
"Hassan" wrote:
> I'd like to get a script/application that would peg all the CPUs. I just
> want to do some load testing, but dont really know how to get my CPUs
> pegged. Can someone help ?
> I just want to max them out for like a couple of minutes.
> And this should work on both 2000/2005
> Thanks
>
>
|||No, I dont want to set the affinity mask. I just want to run a SQL that will
have my CPUs at 100% processor time.
This is for some testing..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...[vbcol=seagreen]
> Hi Hassan
> Do you want to set the affinity mask using sp_configure? See
> http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
> John
> "Hassan" wrote:
|||Hi
I am not sure why SQL Server would have this inbuilt? Try dropping your
indexes and re-running a trace using multiple threads.
John
"Hassan" wrote:
> No, I dont want to set the affinity mask. I just want to run a SQL that will
> have my CPUs at 100% processor time.
> This is for some testing..
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...
>
>
Script to peg all CPUs
I'd like to get a script/application that would peg all the CPUs. I just
want to do some load testing, but dont really know how to get my CPUs
pegged. Can someone help ?
I just want to max them out for like a couple of minutes.
And this should work on both 2000/2005
ThanksNo, I dont want to set the affinity mask. I just want to run a SQL that will
have my CPUs at 100% processor time.
This is for some testing..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...
> Hi Hassan
> Do you want to set the affinity mask using sp_configure? See
> http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
> John
> "Hassan" wrote:
>> I'd like to get a script/application that would peg all the CPUs. I just
>> want to do some load testing, but dont really know how to get my CPUs
>> pegged. Can someone help ?
>> I just want to max them out for like a couple of minutes.
>> And this should work on both 2000/2005
>> Thanks
>>
want to do some load testing, but dont really know how to get my CPUs
pegged. Can someone help ?
I just want to max them out for like a couple of minutes.
And this should work on both 2000/2005
ThanksNo, I dont want to set the affinity mask. I just want to run a SQL that will
have my CPUs at 100% processor time.
This is for some testing..
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E58A3C20-0813-443F-A773-F4B721363D1A@.microsoft.com...
> Hi Hassan
> Do you want to set the affinity mask using sp_configure? See
> http://msdn2.microsoft.com/en-us/library/aa196717(SQL.80).aspx
> John
> "Hassan" wrote:
>> I'd like to get a script/application that would peg all the CPUs. I just
>> want to do some load testing, but dont really know how to get my CPUs
>> pegged. Can someone help ?
>> I just want to max them out for like a couple of minutes.
>> And this should work on both 2000/2005
>> Thanks
>>
Friday, March 23, 2012
Script to cause high CPU
Does anyone have a script that could be run against say AdventureWorks or
Northwind that would peg the CPU to 100% on the servers ?
I want to use it for stress testing. The environment is SQL 2005 and we have
multiple procs.
Thanks
What would be the point of that? What exactly would you be testing for, the
fact you can run at 100% CPU? That would tell you virtually nothing in
regards to your real world system. Here are some tools that can maybe get
you started:
http://support.microsoft.com/default.aspx/kb/231619
http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en
http://www.sql-server-performance.com/articles/per/stress_test_part3_p1.aspx
http://sqljunkies.com/WebLog/amachanic/archive/2005/02/09/7597.aspx
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"John Doe" <Johndoe@.jd.com> wrote in message
news:eJiq2A9ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
> Does anyone have a script that could be run against say AdventureWorks or
> Northwind that would peg the CPU to 100% on the servers ?
> I want to use it for stress testing. The environment is SQL 2005 and we
> have multiple procs.
> Thanks
Northwind that would peg the CPU to 100% on the servers ?
I want to use it for stress testing. The environment is SQL 2005 and we have
multiple procs.
Thanks
What would be the point of that? What exactly would you be testing for, the
fact you can run at 100% CPU? That would tell you virtually nothing in
regards to your real world system. Here are some tools that can maybe get
you started:
http://support.microsoft.com/default.aspx/kb/231619
http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en
http://www.sql-server-performance.com/articles/per/stress_test_part3_p1.aspx
http://sqljunkies.com/WebLog/amachanic/archive/2005/02/09/7597.aspx
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"John Doe" <Johndoe@.jd.com> wrote in message
news:eJiq2A9ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
> Does anyone have a script that could be run against say AdventureWorks or
> Northwind that would peg the CPU to 100% on the servers ?
> I want to use it for stress testing. The environment is SQL 2005 and we
> have multiple procs.
> Thanks
Script to cause high CPU
Does anyone have a script that could be run against say AdventureWorks or
Northwind that would peg the CPU to 100% on the servers ?
I want to use it for stress testing. The environment is SQL 2005 and we have
multiple procs.
ThanksWhat would be the point of that? What exactly would you be testing for, the
fact you can run at 100% CPU? That would tell you virtually nothing in
regards to your real world system. Here are some tools that can maybe get
you started:
http://support.microsoft.com/default.aspx/kb/231619
http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en
http://www.sql-server-performance.com/articles/per/stress_test_part3_p1.aspx
http://sqljunkies.com/WebLog/amachanic/archive/2005/02/09/7597.aspx
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"John Doe" <Johndoe@.jd.com> wrote in message
news:eJiq2A9ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
> Does anyone have a script that could be run against say AdventureWorks or
> Northwind that would peg the CPU to 100% on the servers ?
> I want to use it for stress testing. The environment is SQL 2005 and we
> have multiple procs.
> Thanks
Northwind that would peg the CPU to 100% on the servers ?
I want to use it for stress testing. The environment is SQL 2005 and we have
multiple procs.
ThanksWhat would be the point of that? What exactly would you be testing for, the
fact you can run at 100% CPU? That would tell you virtually nothing in
regards to your real world system. Here are some tools that can maybe get
you started:
http://support.microsoft.com/default.aspx/kb/231619
http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en
http://www.sql-server-performance.com/articles/per/stress_test_part3_p1.aspx
http://sqljunkies.com/WebLog/amachanic/archive/2005/02/09/7597.aspx
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"John Doe" <Johndoe@.jd.com> wrote in message
news:eJiq2A9ZIHA.6140@.TK2MSFTNGP02.phx.gbl...
> Does anyone have a script that could be run against say AdventureWorks or
> Northwind that would peg the CPU to 100% on the servers ?
> I want to use it for stress testing. The environment is SQL 2005 and we
> have multiple procs.
> Thanks
Subscribe to:
Posts (Atom)