Performance Tuning–SQL Server

Many times in your organization an issue is raised that SQL server database is very much slow and its performance is not up to the mark. First thing that comes in mind is are indexes correctly applied to table that are being used? And most of the tim

How to Improve I/O performance for SQL Server

  If underline I/O architecture system is working properly then every time SQL Server do some transaction (Read/Write) it can do it without waiting. But if load on the system is up, then SQL transaction have to wait for their turns for processing. This can significantly reduce SQL Server performance. There is a much greater [...]

The maximum report processing jobs limit configured by your system administrator has been reached.

call Close or Dispose method at the end so the reporting engine remove the report entry from its queue.