Tools or Rule of Thumb

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lanthony - 26 Oct 2005 21:30 GMT

I have a client who has developed a customer sql based app. They want us to
provide hardware and installation. Looking for Tools or Rule of thumb in help
to size server to SQL application. Client has not been able to provide
requirement to us so we are looking to create a questionaire to ask them need
info for build servers to house the SQL requirements

Thanks for any info you can provide

Reply to this Message

Sue Hoegemeier - 27 Oct 2005 17:53 GMT

You can get some ideas on what to ask out of the following
article:
SQL Server 2000 Operations Guide: Capacity and Storage
Management
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlops6.mspx

-Sue

>I have a client who has developed a customer sql based app. They want us to
>provide hardware and installation. Looking for Tools or Rule of thumb in help
[quoted text clipped - 3 lines]
>
>Thanks for any info you can provide

Reply to this Message

Jonathan Miller - 31 Oct 2005 06:32 GMT

Lanthony,

There are a myriad of questions. How big is the database? What is the
expected growth? How many concurrent connections will there be? How does
the app access data, in a disconnected or constantly connected mode? Will
there be a middle tier accessing the data or will the clients connect
directly? You will also want to know how much bandwidth this app is eating.
Do they expect you to performance tune this sucker or just provide
appropriate hardware? Also, if they developed this app it seems like they
must have a development server with a copy of sql installed. This would be a
good place to start benchmarking that app and collecting statistics. Good
Luck!

> I have a client who has developed a customer sql based app. They want us to
> provide hardware and installation. Looking for Tools or Rule of thumb in help
[quoted text clipped - 3 lines]
>
> Thanks for any info you can provide

Reply to this Message