Comments
Sort by recent activity
Sorry - we I think we just didn't get round to that. The issue is in the system (ticket SSR-1184 for interest!) but it's been scheduled for a future release now.
I think I sorted it by name for now at least, but the plan would probably be to make it sortable by whichever column you desire. / comments
Sorry - we I think we just didn't get round to that. The issue is in the system (ticket SSR-1184 for interest!) but it's been scheduled for a future release now.
I think I sorted it by name for now...
jerryhung wrote:
Feature requests [image]
1. Add a group to the list of SQL Servers
so I can classify DEV, UAT, Staging, etc... servers
and perhaps allow Group action such as Set X interval for polling this group, refresh this group, etc..
We didn't add explicit grouping like that - which was a big discussion.. however you can set up and save "Filters" which are a grouping of servers and alert types/levels to display. And for configuration you can create new templates and assign servers to those so they can share common configurations.
jerryhung wrote:
2. Recommendations will include actual fixes if possible?
e.g. for Recommendation "page verify is turned off"
you could show the actual SQL script to do it
ALTER DATABASE DATABASE_NAME SET PAGE_VERIFY CHECKSUM
GO
I can see them handy for
index fragmentation (showcontig/rebuild/reorganize)
backup (so a backup SQL script)
integrity (DBCC CHECKDB script)
excessive space (DBCC SHRINKFILE?)
This again is something that has been discussed and it will certainly be revisited for the next major release - but no promises I'm afraid. / comments
jerryhung wrote:
Feature requests
1. Add a group to the list of SQL Servers
so I can classify DEV, UAT, Staging, etc... servers
and perhaps allow Group action such as Set X interval for polling...
jerryhung wrote:
Feature #1
Any way to configure the frequency of SQL Response poll, perhaps to each server?
say for DEV Servers I only want every 10 mins
for Staging, every 30 mins
for Production (not in house so moot point), I want every 1 minute
It is funny, I am looking at a developer's long running "trace" in Profiler
and he is seeing me/SQL Response in his Profiler ALL THE TIME, which I didn't expect it to be every second
This may put more load onto the "monitored SQL Servers" than I originally expected
For V1.0 the polling is fixed - however different things poll at different rates. For example the performance counters are every 5 seconds - any less and they are just way too inaccurate - and to pick up a long running query of, say, 10 seconds, well we need to poll at least as often as that.
However whilst we run the queries often they are lightweight and should not be contributing any significant overhead
jerryhung wrote:
Feature #2
Is there a REFRESH ALL button that go fetches & updates the real-time stats
Say I saw a Recommendation, went to the server and did it, I want to refresh right away to see if it's gone
This was one of the features that was on the list but didn't make the cut for 1.0 I'm afraid. Hopefully it will be put in for the next feature release. / comments
jerryhung wrote:
Feature #1
Any way to configure the frequency of SQL Response poll, perhaps to each server?
say for DEV Servers I only want every 10 mins
for Staging, every 30 mins
for Product...
I understand your problem - however there was no easy way to connect to a SQL server with windows authentication other than the user running the program (unless you resort to impersonation which then brings a new set of worries)
I'm afraid the only way to change the credentials is to re-install or to change the user who runs the alert repository service (which means you have to have 1 user for all servers or use SQL Server authentication - or install more than one alert repository) / comments
I understand your problem - however there was no easy way to connect to a SQL server with windows authentication other than the user running the program (unless you resort to impersonation which th...
You're not the first to mention this and I'm trying to recall the discussion we had internally where we decided to not put this in!
I think we were worried that the database can actually change if there are "use" statements in there and so it may be inaccurate, but with long query the time at which we capture the SQL the DB context would be more relevant.
Sadly it's too late to add this to V1.0 but should be easy to add in the future. / comments
You're not the first to mention this and I'm trying to recall the discussion we had internally where we decided to not put this in!
I think we were worried that the database can actually change if ...
Glad it's working for you now and thanks for persevering with it [image] If it happens again then please do let us know. / comments
Glad it's working for you now and thanks for persevering with it If it happens again then please do let us know.
Hi,
Sorry - I'm a little confused as to what you mean by "lost the repository"?
SQL response doesn't actually get installed against and database - it uses an embedded SQL engine and stores it's own datafiles in "c:\documents and settings\all users\red gate\sql response" or some such. Once done you then add servers to be monitored.
Upgrading to SQL 2008 should not affect response at all and once the upgraded instance is back and running then response will try to connect and report on the new instance. We have tested against 2008 and it should be working fine. / comments
Hi,
Sorry - I'm a little confused as to what you mean by "lost the repository"?
SQL response doesn't actually get installed against and database - it uses an embedded SQL engine and stores it's own...
We should be using 64-bit ulongs for things size related, but one must have slipped through the net.
Could you please send me the log files which can be found in
C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\Logs\SQL Response AlertRepository
to nigel.morse at red-gate.com which should help me pinpoint the location.
We have tested some pretty large databases - but I don't think we even have 18Tb of disk to even try that size!!
Thanks / comments
We should be using 64-bit ulongs for things size related, but one must have slipped through the net.
Could you please send me the log files which can be found in
C:\Documents and Settings\<user ...
I think a screeny would be helpful please - to nigel.morse at red-gate.com. Thanks [image] / comments
I think a screeny would be helpful please - to nigel.morse at red-gate.com. Thanks
There was a small issue that was fixed after the release where by all files would appear in the UI as red (i.e. had excessive space) even though only 1 of them actually did. And I've just found why it probably wasn't reporting the log one. / comments
There was a small issue that was fixed after the release where by all files would appear in the UI as red (i.e. had excessive space) even though only 1 of them actually did. And I've just found wh...