question

rachit.dba avatar image
rachit.dba asked

doing re-indexing on transaction table again application works fine

I have an OLTP database using platform Sql Server 2012, This application issues certificate No when transaction completed. I have faced a problem two time within a week that Issuing of certificate No. has stopped suddenly while there is no lock on any tables but when doing re-indexing on transaction table again application works fine. Kindly suggest what can be possible cause.
index
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.