Activity overview
Latest activity by Scott Herbert
Querying/Reporting from SQL Response
I'd like to be able to make the performance of our SQL Servers more transparent to my bosses. In particular, I'd like to be able to report on worst queries for blocking, most common deadlock situat...
Forgive me, I had inconsistently applied the syntax on different databases' restore jobs. Deleting this thread might be best for everyone involved! :oops: / comments
Forgive me, I had inconsistently applied the syntax on different databases' restore jobs. Deleting this thread might be best for everyone involved! :oops:
Don't worry, you're not the only one! I think the way it works is fairly non-intuitive and should be configurable per alert type. / comments
Don't worry, you're not the only one! I think the way it works is fairly non-intuitive and should be configurable per alert type.
Log Shipping - Cleaning up Restored Files
I've done a fair bit of searching the forums etc., so forgive me if this has been answered elsewhere:
I'm running the below code to restore the t-logs:DECLARE @errorcode INT
DECLARE @sqlerrorcode I...
Just one thing which might be helpful in FAQs, manuals etc for this product is making clear which machine is being talked about when file locations are given. The monitored server? The machine on which the repository is located? etc.
I've sent an email containing the logs which were stored on the repository machine. / comments
Just one thing which might be helpful in FAQs, manuals etc for this product is making clear which machine is being talked about when file locations are given. The monitored server? The machine on w...
Collecting Trace Data
I have enabled the collection of trace data on both servers which are being monitored. However, I am yet to see any trace data appear in the performance snapshot for any alert. I have checked deadl...
I had this problem as well. Swore a bit, re-entered my serial numbers and all was back to normal. Fingers crossed it doesn't happen again. / comments
I had this problem as well. Swore a bit, re-entered my serial numbers and all was back to normal. Fingers crossed it doesn't happen again.
seconded on this one; i currently have my own jobs and reports tracking mdf size and would love to have this integrated into sql response. / comments
seconded on this one; i currently have my own jobs and reports tracking mdf size and would love to have this integrated into sql response.
I'm on a 32bit server, with 32GB of RAM. /PAE is in the boot.ini, AWE is enabled, "Lock Pages in Memory" permission given to SQL's account and and max and min memory set so that SQL will use 30Gb of that 32GB and hang on to it.
I'm getting a Low Physical Memory error, saying that SQL Server was using 317.9MB, Other Processes Using 25.6GB, and Free Space = 6.1GB.
The "Other Processes" figure looks wrong.
I suspect that SQL Response is failing to recognise memory usage correctly in my configuration. Are there any logs etc., that I can supply to help identify this problem? / comments
I'm on a 32bit server, with 32GB of RAM. /PAE is in the boot.ini, AWE is enabled, "Lock Pages in Memory" permission given to SQL's account and and max and min memory set so that SQL will use 30Gb o...
Great news Ben, thanks. / comments
Great news Ben, thanks.