Inconsistent Database Performance

Hi,

I am facing a peculiar problem while looking ahead in a live Database
currently under operation in one of my clients Project. An
Application that is updating 3 - tables in the Database is missing to
update a certain number of Fields in one of the Tables. The fact is
not frequent and I have checked through the Server Performance Monitor
that there is no performance slag of the Server during any point of
time.

The Tables are indexed with common Key fields. Can anybody help me in
this regard ?

Thanks & Regards.

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Dis...pict193836.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=655931"gangulyarindam" <UseLinkToEmail@.dbForumz.com> wrote in message
news:42010bd1$1_5@.alt.athenanews.com...
> Hi,
> I am facing a peculiar problem while looking ahead in a live Database
> currently under operation in one of my client's Project. An
> Application that is updating 3 - tables in the Database is missing to
> update a certain number of Fields in one of the Tables. The fact is
> not frequent and I have checked through the Server Performance Monitor
> that there is no performance slag of the Server during any point of
> time.
> The Tables are indexed with common Key fields. Can anybody help me in
> this regard ?
> Thanks & Regards.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/General-Dis...pict193836.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=655931

You can use Profiler to see exactly what commands the application is sending
to MSSQL - sometimes an application may not be doing what you think it is,
especially if it builds SQL strings dynamically.

If that doesn't help, you would need to give some more information about
your environment and exactly what is going wrong.

Simon|||gangulyarindam (UseLinkToEmail@.dbForumz.com) writes:
> I am facing a peculiar problem while looking ahead in a live Database
> currently under operation in one of my client's Project. An
> Application that is updating 3 - tables in the Database is missing to
> update a certain number of Fields in one of the Tables. The fact is
> not frequent and I have checked through the Server Performance Monitor
> that there is no performance slag of the Server during any point of
> time.
> The Tables are indexed with common Key fields. Can anybody help me in
> this regard ?

There is far too little information to give much useful advice. But
it certainly sounds like an application problem to me. Maybe there is
some bad error handling. Maybe you have a poor transaction scope, so
that the update is carried out partly.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp