|
Home > Archive > MS SQL Server > February 2006 > sql server performance issues
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]
| Author |
sql server performance issues
|
|
| ChiWhiteSox 2006-02-06, 11:23 am |
| hi,
can anybody give me any suggestions on how to speed up the performance of
our sql server?
Here's the current setup:
We got a main transaction database of 80gb of data, indexed by
recordID,lastname,fi
rstname,( at least 15 fields).
When our clients (about 50-100) start viewing the stats site online, it gets
really slow on showing the data. Basically we show them the daily unique
lastnames or by telephone numbers for the past 2-3 months. It is all querying
it from that main table with other small tables doing some inner joins. It's
just soooo slow in getting the distincts,uniques, total etc for a particular
demographic. We did reindexing but it doesnt seem to do any good.
any suggestions would be highly appreciated.
Thanks!
| |
| Rick Sawtell 2006-02-06, 1:23 pm |
|
"ChiWhiteSox" < ChiWhiteSox@discussi
ons.microsoft.com> wrote in message
news:A0C00E00-0E81-46FD-9381- 090C9CA48D61@microso
ft.com...
> hi,
>
> can anybody give me any suggestions on how to speed up the performance of
> our sql server?
>
> Here's the current setup:
> We got a main transaction database of 80gb of data, indexed by
> recordID,lastname,fi
rstname,( at least 15 fields).
>
> When our clients (about 50-100) start viewing the stats site online, it
> gets
> really slow on showing the data. Basically we show them the daily unique
> lastnames or by telephone numbers for the past 2-3 months. It is all
> querying
> it from that main table with other small tables doing some inner joins.
> It's
> just soooo slow in getting the distincts,uniques, total etc for a
> particular
> demographic. We did reindexing but it doesnt seem to do any good.
>
> any suggestions would be highly appreciated.
>
> Thanks!
Sounds like a perfect Data Warehouse solution. Barring that, you may wish
to create some archive tables which only carry your 2-3 months worth of
data. Indexed Views may be an option as well.
Rick Sawtell
MCT, MCSD, MCDBA
|
|
|
|
|