Hi,
We have recently upgraded one of our application after which we have been
facing lot of blocking issues at DB level.Our application vendor claims that
nothing much has been changed at DB layer level and he indicates something is
wrong with our DB enviornment.Can somebody help me in allevaiteing these DB
blocks?
RectThat's a silly response from the vendor - so they changed
the application and don't think that could have anything to
do with the sudden issues with blocking? It could very much
play a part. The indexing needs often change with a new app
as well.
The following links should help you out with setting up
monitoring for blocking:
INF: Understanding and Resolving SQL Server 7.0 or 2000
Blocking Problems
http://support.microsoft.com/?id=224453
INF: How to Monitor SQL Server 2000 Blocking
http://support.microsoft.com/?id=271509
-Sue
On Tue, 25 Apr 2006 16:52:01 -0700, Rect
<Rect@.discussions.microsoft.com> wrote:
>Hi,
>We have recently upgraded one of our application after which we have been
>facing lot of blocking issues at DB level.Our application vendor claims that
>nothing much has been changed at DB layer level and he indicates something is
>wrong with our DB enviornment.Can somebody help me in allevaiteing these DB
>blocks?
>Rect
No comments:
Post a Comment