My present config is
1. SQL 2000 - standard
2. Windows 2000 server - standard
3. SQL data - 1G physical size
4. ram - 3G size

i am now considering faster platform

Would it have significant improvement if the platform is changed to
1. SQL2005 or SQL2008 (newer version)
2. Windows 2003 64bit (more usable memory)
3. ram 3G upgrade to 10G (but the physical data size is 1G)
4. upgrade from standard version to enterprise or datawarehouse version.

you may ignore CPU & hard drive since i have an option to buy a new hardware
server and use back the present software (SQL2K, windows 2000)

grateful for any opinions. thanks a lot.

tony

Tony WONG wrote:
> My present config is
> 1. SQL 2000 - standard
> 2. Windows 2000 server - standard
> 3. SQL data - 1G physical size
> 4. ram - 3G size
>
> i am now considering faster platform
>
> Would it have significant improvement if the platform is changed to
> 1. SQL2005 or SQL2008 (newer version)
> 2. Windows 2003 64bit (more usable memory)
> 3. ram 3G upgrade to 10G (but the physical data size is 1G)
> 4. upgrade from standard version to enterprise or datawarehouse version.
>
> you may ignore CPU & hard drive since i have an option to buy a new hardware
> server and use back the present software (SQL2K, windows 2000)
>
> grateful for any opinions. thanks a lot.
>

Well

It depends not necessary you will be pleased with new platform.
First - SQL database it's really small 1GB
Second usually database performance depends on



-Database project //queries,structure,tables indexes etc.
-number of users
-defragmentation
--etc ...

Hardware

-I/O subsytem
-Memory RAM
-CPU

the best way it's to use routine to find bottleneck .

i.e
run perfmon and check counters like that

Memory: Pages/sec
Memory: Available Bytes
SQL Server: Buffer Manager: Buffer Cache Hit Ratio
Physical Disk: Disk Reads/sec
Physical Disk: Disk Writes/sec
Physical Disk: % Disk time
Physical Disk: Avg. Disk Queue Length
Processor: % Processor Time
System: Processor Queue Length
Network Interface: Bytes Received/sec
Network Interface: Bytes Sent/sec
Network Interface: Output Queue Length
SQL Server: General: User Connections
SQL Server: SQL Statistics: Batch Requests/sec
SQL Server: SQL Statistics: SQL Compilations/sec
SQL Server: SQL Statistics: SQL Recompilations/sec
Lock Waits
Log Buffer Waits
etc IO/stats

then you need to find out where is bottleneck .

In google you will find a lot articles about SQL server performance .

So in a nutshell before you decide to change platform check where
bottlenecks are.

regards
SW






> tony
>
>

Thanks Sebastian


"Sebastian Waksmundzki" <sebwaks@yahoo.co.uk>
???????:%23PuTya8FIHA.4584@TK2MSFTNGP03.phx.gbl...
> Tony WONG wrote:
>> My present config is
>> 1. SQL 2000 - standard
>> 2. Windows 2000 server - standard
>> 3. SQL data - 1G physical size
>> 4. ram - 3G size
>>
>> i am now considering faster platform
>>
>> Would it have significant improvement if the platform is changed to
>> 1. SQL2005 or SQL2008 (newer version)
>> 2. Windows 2003 64bit (more usable memory)
>> 3. ram 3G upgrade to 10G (but the physical data size is 1G)
>> 4. upgrade from standard version to enterprise or datawarehouse version.
>>
>> you may ignore CPU & hard drive since i have an option to buy a new
>> hardware
>> server and use back the present software (SQL2K, windows 2000)
>>
>> grateful for any opinions. thanks a lot.
>>
>
> Well
>
> It depends not necessary you will be pleased with new platform.
> First - SQL database it's really small 1GB
> Second usually database performance depends on
>
>
>
> -Database project //queries,structure,tables indexes etc.
> -number of users
> -defragmentation
> --etc ...
>
> Hardware
>
> -I/O subsytem
> -Memory RAM
> -CPU
>
> the best way it's to use routine to find bottleneck .
>
> i.e
> run perfmon and check counters like that
>
> Memory: Pages/sec
> Memory: Available Bytes
> SQL Server: Buffer Manager: Buffer Cache Hit Ratio
> Physical Disk: Disk Reads/sec
> Physical Disk: Disk Writes/sec
> Physical Disk: % Disk time
> Physical Disk: Avg. Disk Queue Length
> Processor: % Processor Time
> System: Processor Queue Length
> Network Interface: Bytes Received/sec
> Network Interface: Bytes Sent/sec
> Network Interface: Output Queue Length
> SQL Server: General: User Connections
> SQL Server: SQL Statistics: Batch Requests/sec
> SQL Server: SQL Statistics: SQL Compilations/sec
> SQL Server: SQL Statistics: SQL Recompilations/sec
> Lock Waits
> Log Buffer Waits
> etc IO/stats
>
> then you need to find out where is bottleneck .
>
> In google you will find a lot articles about SQL server performance .
>
> So in a nutshell before you decide to change platform check where
> bottlenecks are.
>
> regards
> SW
>
>
>
>
>
>
>> tony
>>
>>