Hi, evaluating the SQL Response tool, here are some details:
-OS: Windows 2003R2 Server, SP2, x64
-OS: Windows 2008R2 Enterprise, x64
-SQL: SQL Server 2005, Enterprise, SP3 ,64 bit
A few issues I'm noticing. First, I'm not receiving all the alerts I think I should be. I do receive some (Low Disk Space errors for example) but not all. For example, I have 'tracing' turned on for the SQL Server and I'm monitoring for 'Long running queries' of 2 sec or more. I have profiler pulled up doing the same thing. I have received many hits in profiler for qualifying queries BUT SQL Response hasn't seen one.
Secondly, I'm having the 'This alert is still being written to' issue on some of the alerts.. After reading the forum and a link to a support article on how to handle it, I set the 'Centralized Exceptions' list for Symantec Endpoint Protection to point at the RedGate folders in Program Files and in /All Users/Application Data/. I also destroyed the repository and reinstalled it. Still no alerts. Any other tricks to try?