MS-SQL 2000 SP2

I have a client that has noticed a "slowness in reads" during a performance
benchmark. They mentioned something about a MS-SQL "fix" to improve read
performance. Is there such a fix or patch? I know this is real vague but
it's all the information I have.All publicly available "fixes" are available through the service packs.
Microsoft Support may issue individual patches for specific problems to
resolve support cases, however these are only available after opening a case
with tech support or by specific reference in certain knowledgebase
articles. Without knowing exactly what "fix" your client is referencing,
its hard to provide additional information. I'd double check with them to
get some additional details.
--
--Brian
(Please reply to the newsgroups only.)
"Jo Ratner" <jo_ratner@.NOSPAMyahoo.com> wrote in message
news:riURb.466$jH6.359@.newsread1.news.atl.earthlink.net...
>I have a client that has noticed a "slowness in reads" during a performance
> benchmark. They mentioned something about a MS-SQL "fix" to improve read
> performance. Is there such a fix or patch? I know this is real vague but
> it's all the information I have.
>|||Hi
Although I dont know of any "fix" there are alot of things you can do to
improve reads.. ranging from changing SQL, adding/updating
indexes/statistics to additional hardware or a change of O/S. Windows 2003
has a improved file system that in turn improves SQL Server performance. It
could even be the way the tests are being run.
Without analysing the problem you may not know exacly where the problem(s)
may occur.
The latest service pack is 3a, and, as this contains several security fixes
it would be sensible to use this. It would be reasonable to assume any
system being implemented would be atleast at this level, a system on Service
pack 2 may not be representative.
John
"Jo Ratner" <jo_ratner@.NOSPAMyahoo.com> wrote in message
news:riURb.466$jH6.359@.newsread1.news.atl.earthlink.net...
> I have a client that has noticed a "slowness in reads" during a
performance
> benchmark. They mentioned something about a MS-SQL "fix" to improve read
> performance. Is there such a fix or patch? I know this is real vague but
> it's all the information I have.
>|||It was an invalid benchmark test...
Thanks!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:bvft13$cal$1@.sparta.btinternet.com...
> Hi
> Although I dont know of any "fix" there are alot of things you can do to
> improve reads.. ranging from changing SQL, adding/updating
> indexes/statistics to additional hardware or a change of O/S. Windows 2003
> has a improved file system that in turn improves SQL Server performance.
It
> could even be the way the tests are being run.
> Without analysing the problem you may not know exacly where the problem(s)
> may occur.
> The latest service pack is 3a, and, as this contains several security
fixes
> it would be sensible to use this. It would be reasonable to assume any
> system being implemented would be atleast at this level, a system on
Service
> pack 2 may not be representative.
> John
> "Jo Ratner" <jo_ratner@.NOSPAMyahoo.com> wrote in message
> news:riURb.466$jH6.359@.newsread1.news.atl.earthlink.net...
> > I have a client that has noticed a "slowness in reads" during a
> performance
> > benchmark. They mentioned something about a MS-SQL "fix" to improve
read
> > performance. Is there such a fix or patch? I know this is real vague
but
> > it's all the information I have.
> >
> >
>