Hi All,

I had two Window NT 4.0 Server, say A and B... We recently upgraded
from SQL Server 6.5 to SQL Server 2000 on Computer A, and for
Computer B, I installed SQL Server 2000 from scratch. These two have a
same RAM(512MB) and CPU speed...so the setup for hardware is almost
identical...

For server A, there are around 10 connection to this SQL Server...
For server B, there are also around 10 connection to this SQL
Server...

The database for SQL Server B is a copy from SQL Server A.... I
restored the database on SQL Server B from the backup dump of Server
A...

We have a store procedure called usp_GetMemo(ID Interger) ... we feed
ID number to this store procedure and return its return Description...
this table has ID column and it's Non-Cluster index, allow the
duplicate row... there are 1.7 million records for this table...

Here is problem... whenever i execute more than 100 times for this
store procedure(usp_GetMemo(ID)) continuously, the CPU usage of
Computer A is 3 times bigger than computer B....

i did run the command "DBCC DBReindex" , "Update Statistics" for this
table on computer A, but did not make any difference... what else
should i try??

Any help will be really appreciated,
Thanks alot,
Kim,

kim wrote:
You posted to the wrong group! This is the Sybase ASE newsgroup.