I have a client that is currently running SQL 05 (the workgroup
edition) as installed in SBS2K3 R2. The limitations of SBS (RAM and
has to be installed on SBS box with exchange) is causing bottle necks.
The have 25 users varying from moderate to heavy sql load. 20 users
access through a single TServer.

I will be upgrading to sql 2008 and moving all production DB off the
SBS and am considering using the current TServer hardware and would
appreciate some feedback. The TServer is a dell 2950 667 FSB, dual
XEON processors, hardware raid (6 SCSI 15,000 rpm drives) 8 RAM slots
(32GB max)

Any feedback on how this might perform as a SQL Server 2008 if I use
it as the TServer as well?

Dear MM,

Can you provide the hardware configuration of your SBS server as well.

Regards, Balaji

"MM" <nosend2me (AT) hotmail (DOT) com> wrote

On Nov 9, 12:41*am, "Balaji" <tbalajipra... (AT) gmail (DOT) com> wrote:
Thanks for your post... SBS is a twin Dell 2950 SBS hardware raid 6
drives, Max RAM = 4GB and with all the SBS activity (runs Exchange,
ISA, AV, WSUS, imaging backups etc) plus SQL is is struggling. We have
5 main sql DBs that interact heaviest used is approx 20GB and is used
all day by all users plus EDI interaction with retail order processing
etc.

Dear MM, The T Server you are mentioning here is it terminal server. Where
you able to find why SQL Server is running slow? What is the CPU, Memory, IO
usage on the SBS Server?

Regards, Balaji
The T Ser
"MM" <nosend2me (AT) hotmail (DOT) com> wrote

On Nov 9, 12:41 am, "Balaji" <tbalajipra... (AT) gmail (DOT) com> wrote:
Thanks for your post... SBS is a twin Dell 2950 SBS hardware raid 6
drives, Max RAM = 4GB and with all the SBS activity (runs Exchange,
ISA, AV, WSUS, imaging backups etc) plus SQL is is struggling. We have
5 main sql DBs that interact heaviest used is approx 20GB and is used
all day by all users plus EDI interaction with retail order processing
etc.

On Nov 10, 5:26*am, "Balaji" <tbalajipra... (AT) gmail (DOT) com> wrote:
Balaji, thanks for your post. The primary issue seems to be RAM on the
SBS (limited to 4GB) it is always at 100%+++ all in use with exchange
etc and sql has ro keep giving it up. Seldom is CPU or newtowrk
traffic and an issue. On ocassion it is DISK IO which I beleive is
when it's swapping to disk. The TServer and SBS are two identical
servers.