Activity overview
Latest activity by fhtapia
Long Response Time on Open Incidents
When I click on the Open Incidents. I get a short list of incidents' for the server, incident type, etc. Why is the Server column there? can I select more than one server at a time?
There is a l...
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?
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...
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 ...
Sql Prompt V3 beta trial expired???
I wanted to try the re-fresh update to see how the changes were behaving, I upgraded today but I received the error: Your trial could not be extended... any reason why, this is a beta...
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....
JOIN ON support?
Hi, I just started using Sql Prompt 3 after finding the announcement, I've been using Sql Prompt for at least 6 months now and I really love it. Sql Prompt 2 had support for the ON clause where I ...
ERROR 660
I am getting the following error on a Windows 2003 server w/ Sql Server 2000 SP4, I have successfully installed the server components on other W2003 Sql 2000sp4 servers, why is thisone any diffrent...