Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2007-07-13 : 05:01:51
|
| This quote is from the MS websitePerformance limitations in SQL Server ExpressThe SQL engine of SQL Server Express supports 1 CPU, 1 GB RAM and a 4 GB database size. This distinction gives SQL Server Express well defined cut-off points to differentiate it from other SQL Server 2005 editions. Unlike MSDE, SQL Server Express eliminates the confusion created by the workload governor.1 CPU: SQL Server Express can install and run on multiprocessor machines, but only a single CPU is used at any time. This limitation prevents the use of parallel query execution in SQL Server Express.--------------------My question is regarding the processors, i've developed a stress testing application to measure our database performance, when I run it at full both processors jump to 100%, Reading the MS quote I thought that only 1 processor could be used? Am I missing something?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-13 : 05:20:05
|
| In what environment do you run the stress test application?DB?.Net?Peter LarssonHelsingborg, Sweden |
 |
|
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
Posted - 2007-07-13 : 05:24:32
|
| Its just a windows forms application written in VB.NET |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-13 : 08:31:30
|
perhaps there's another cpu-hog on the same machine? IIS?
elsasoft.org |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-07-13 : 08:40:47
|
| SQL Express can only utilize one processor, right.What about your stress test application? Is this the one who spikes the other processor?Peter LarssonHelsingborg, Sweden |
|
|
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
Posted - 2007-07-16 : 06:39:49
|
| Well, i'm running it locally, not on the SQL server itself so the only thing that can be causing the CPU to peak in the actual queries?Strange. |
|
|
|
|
|
|
Performance question