|
Home > Archive > MS SQL Server > October 2006 > Suitable Hardware
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| Hi,
I have a database containing 1GB data. I have tuned all of queries and
indexes and they perform good comparing with the current hardware. But still
we lack performance! My boss has admitted that the server's hardware must be
upgraded but its my task to choose and offer the appropriate hardware. I'd
like to know how this must be done. Are there any documents explaining that
which upgrade (CPU, DISK or RAM) is critical in particular scenario? What
kind of measurements must be done?
Any help would be greatly appreciated.
Leila
| |
| Linchi Shea 2006-10-24, 6:33 pm |
| Before getting to the question of what hardware may be good for an upgrade,
I'd first get an understanding of the database performance in terms of where
the bottleneck may lie, and add hardware to address that bottleneck. For
instance, if it's processor bound, it may not help that much to a faster disk.
Linchi
"Leila" wrote:
> Hi,
> I have a database containing 1GB data. I have tuned all of queries and
> indexes and they perform good comparing with the current hardware. But still
> we lack performance! My boss has admitted that the server's hardware must be
> upgraded but its my task to choose and offer the appropriate hardware. I'd
> like to know how this must be done. Are there any documents explaining that
> which upgrade (CPU, DISK or RAM) is critical in particular scenario? What
> kind of measurements must be done?
> Any help would be greatly appreciated.
> Leila
>
>
>
| |
| Martin Poon [MVP] 2006-10-24, 6:33 pm |
| Here's a comprehensive reference on troubleshooting performance problems in
SQL Server 2005.
http://www.microsoft.com/technet/pr...5/tsprfprb.mspx
--
Martin Poon
Microsoft MVP - SQL Server
--------------------------------------------------
- SQL Server 2005 / 2000 books online
http://www.microsoft.com/technet/pr...oads/books.mspx
http://www.microsoft.com/sql/prodin...ions/books.mspx
====================
====================
==========
"Leila" <Leilas@hotpop.com> ¦b¶l¥ó
news:uuEnUlY5GHA.2464@TK2MSFTNGP06.phx.gbl ¤¤¼¶¼g...
> Hi,
> I have a database containing 1GB data. I have tuned all of queries and
> indexes and they perform good comparing with the current hardware. But
still
> we lack performance! My boss has admitted that the server's hardware must
be
> upgraded but its my task to choose and offer the appropriate hardware. I'd
> like to know how this must be done. Are there any documents explaining
that
> which upgrade (CPU, DISK or RAM) is critical in particular scenario? What
> kind of measurements must be done?
> Any help would be greatly appreciated.
> Leila
>
>
|
|
|
|
|