(imported topic written by gregarnold91)
All,
We have a BES SQL DB on a 2005 SQL server that has about 75 other databases - We are starting to have performance issues with some applications that use these other databases…is there any reason why BES should run on a SQL server stand-alone?
(imported comment written by SystemAdmin)
Hi gregarnold,
Yes, it is highly recommended to give BES a dedicated SQL Server. The real-time nature of BES puts a constant load on SQL and requires constant updating. The primary contention point is going to be on the disks since BES is constantly trying to update data the disks will thrash between BES and the other applications. You could try to put BES onto dedicated disks on the SQL Server but its basically asking for trouble by putting BES on a shared SQL Server. We recommend putting SQL Server on the BES Server to avoid these types of contention issues and to ensure we receive consistent performance.
(imported comment written by SystemAdmin)
I put together a KB article on this as well, we have always recommended using a dedicated SQL Server but I could find anything that spelled it out clearly.
(imported comment written by gregarnold91)
Excellent. Thank you for your help.
We are a rather large corporation and we are struggling with this issue - I appreciate your direction.