Comments
Sort by recent activity
Well it seems to be slightly faster once it's loaded for the time. The initial time it takes over 30seconds, but after that I would say it takes about 5 seconds.
One question on the recommendation of excessive Free space. Some of these databases are pre-grown out so that the data will grow to the size of the file. We generally grow the database once a month. Can this tool trend the growth? or provide a report of current growth, I don't see that anywhere in the menus. / comments
Well it seems to be slightly faster once it's loaded for the time. The initial time it takes over 30seconds, but after that I would say it takes about 5 seconds.
One question on the recommendation...
The monitoring process, when does it collect the stats for the server? How do I change the timing? / comments
The monitoring process, when does it collect the stats for the server? How do I change the timing?
in my initial for Sql Response I noticed that many of it's initial tasks seem to be simply very slow. both Open Inidents and Recommendations take a very long time to load up. Is the system monitoring independently or only while I select the server?
btw, it may be possible that it is slow because my database has > 68K tables. Perhaps a way to cache some of this data would be helpful??? / comments
in my initial for Sql Response I noticed that many of it's initial tasks seem to be simply very slow. both Open Inidents and Recommendations take a very long time to load up. Is the system monito...
The error I got on a machine that has Sql 4.6 installed I received this error:
note I did not uninstall 4.6 over it, I just went and installed 5 straight
The extended stored procedure file(xp_sqlbackup.dll) that exists is an earlier version. Check that you have rights to overwrite the existing file, and run the installation again.
Setup failed to check that the SQL Backup extended stored procedures were installed. / comments
The error I got on a machine that has Sql 4.6 installed I received this error:
note I did not uninstall 4.6 over it, I just went and installed 5 straight
The extended stored procedure file(xp_sqlba...
I keep getting intermitten errors where my Query Analyzer window will have multiple Sql-prompt menus. This doesn't happen all the time but occassionally I will have multiple windows within one QA session open, then I'll open another QA session, and that window will be normal, but my primary QA window will suddenly have as many as 6 Sql Prompt Menus. / comments
I keep getting intermitten errors where my Query Analyzer window will have multiple Sql-prompt menus. This doesn't happen all the time but occassionally I will have multiple windows within one QA ...
One more thing... If I explicitly join a table I no longer have support for just the fields I wanted case in point:
SELECT A.Field1, A.Field2, B.Field1
From TableA AS A INNER JOIN TableB AS B ON A.FieldPK = B.FieldPK
When I type B. SqlPrompt2 would list me a set of fields related only to Table B if I did A. I would get a list of only fields in tableA, Sql Prompt3 doesn't seem to do that, it seems to give me all the fields wich is not useful at all.
Thanks, / comments
One more thing... If I explicitly join a table I no longer have support for just the fields I wanted case in point:
SELECT A.Field1, A.Field2, B.Field1
From TableA AS A INNER JOIN TableB AS B ON A....