Jump to content

SQL Express performance decreasing...

NewsBot
 Share

Recommended Posts

NewsBot Newbie

NewsBot

Posted
Posted

Each of the computers that my app runs on has a SQL express database.

 

However, it seems that over the course of a few months, the performance of the database seems to be degrading, with occasional timeouts etc too.

 

I have tried running the expressmaint utility, using both REINDEX and REORG, and I am waiting to hear whether that has been successful from my sites.

 

Should the utility make a difference? Also, is there anything else I should be running against these databases to keep the performance optimal?

 

The application is pretty hard on the database, It can be running a few thousand inserts throughout the day, along with lots of queries, and deletes....

 

 

More...

 

View All Our Microsoft Related Feeds

View All Our Microsft Related Feeds
  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...