When I select alerts in the Pharos Administrator I receive the following error "Unable to load the full list of Alerts"

What does it mean when I select alerts in the Pharos Administrator I receive the following error "Unable to load the full list of Alerts"

This means that the alerts log is very full so big that the SQL temporary database, which temporarily moves this information around, is not capable of handling the quantity of data. The best option is to purge some of the older transactions. To do this do the following:

1. open the Pharos Administrator

2. select \system alerts

3. click the blue Archive button at the top of the screen

4. select the copy and remove data

5. select the file copy location

6. select either dates from a range or all alerts

7. select finish

This will remove transactions allowing the tempdb to recover and display all relevant alerts. This should be purged about once every 6 months or so.

The other alternative is to increase the size of the tempdb database. To do this do the following

1. open the SQL Enterprise Manager

2. select the server\databases

3. right click on the tempdb database and open up properties

4. then select the data files tab

5. increase the size of tempdb to 10 meg by highlighting the space allocated and increasing the figure

6. click ok

This will allow more space to the tempdb and allow the data to transfer through the tempdb database to the Pharos Administrator. Refer attached screen shots for specific screen detail.