What to do if your database seems slow

Software development Concepts, SQL Tips
What to do if your database seems slow Quite a few times during a business day or even after hours, you have noticed that your database requests or queries tend to be slow with the results.  This could be that your database has become bloated with constant usage.  There are a few things that the IT / DBA or you, can do to resolve these possible serious issues. Databases work almost like people, they tend to keep inactive data that uses disk space, poor design and even the over-indexing of tables which could be some of the reasons for poor performance to outright collapse. Step one - inactive data to archives. The first step is to research whether there is too much inactive data.  This is data that is no…
Read More