Effect of Dual Xeon on ASP code and SQL queries

TechBoyJK

Lifer
Oct 17, 2002
16,699
60
91
Hi,

I work for a hosting company and a client is wishing to upgrade to a dedicated xeon server. Here is the clients explanation of concern.

It seems the obvious thing for us to do would be to go to a dual-Xeon server. We are concerned, however, since the client does not want to do any significant recoding of the web site. We are presently using asp and MS SQL desktop edition. There are a number of asp pages where we, for example, do an insert into a table and then query the table to get an auto-incremented id from the insert query. We are concerned that the dual processor system (or even hyperthreading on a single Xeon) might require recoding to avoid
concurrency problems with these sorts of SQL queries.

Any comments?
 

gramboh

Platinum Member
May 3, 2003
2,207
0
0
No idea about this sort of thing, but search for Microsoft's official USENET news groups on http://groups.google.com - there are MS tech people there that can probably give you the correct answer re: MS SQL.