Comments
Sort by recent activity
SQL Compare will only sync things at the database level, whereas a SQL agent job is a server level object. We used to have this functionality in DTS Compare v1.x, which we had retired and replaced with DTS Package Compare which does not have the jobs and other things in it. Even with DTS Compare 1.x, though, you could not actually synchronize jobs, only compare them.
But you may want to check out our Multi-script product. You can take the SQL Agent job and do a 'script as create' in SQL Server then, once you have the script, you can apply it to multiple servers using multi-script.
If you want to create new jobs for different databases on the same server, you could script the sql agent job, and then just manually change the database name, frequency etc in the script and run it on the server.
Hope this helps! / comments
SQL Compare will only sync things at the database level, whereas a SQL agent job is a server level object. We used to have this functionality in DTS Compare v1.x, which we had retired and replaced ...
I'm afraid I don't have much to suggest except looking at the log files or trying to reproduce the problem here.
Log files are in:
C:\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\ANTS Performance Profiler 4
If you'd like me to reproduce, you could mail the project files to support@red-gate.com (using any archiver except zip). / comments
I'm afraid I don't have much to suggest except looking at the log files or trying to reproduce the problem here.
Log files are in:
C:\Documents and Settings\<user name>\Local Settings\Application D...
No, sorry. We know this is a highly desirable feature and we are considering it for a future release (which will have to be after our next major release (which is version5)). It is a significant architectural change so we need to be sure its the right way to go with Product development.
If you have specific scenarios in mind that would be solved by this feature please let us know and we will add it to the justification for including it. / comments
No, sorry. We know this is a highly desirable feature and we are considering it for a future release (which will have to be after our next major release (which is version5)). It is a significant ar...
Hi.
Thanks for your question.
Obviously I can't go into too much details about the exact techniques of the application but the general technique is one of IL injection and using the perfomance counter objects supplied by the Framework.
You are correct in what you say about the overhead this causes - ususally you would hardly notice the effect of the profiler but certain code blocks (such as very tight loops) can give an exaggerated effect. However, the profiler does use an algorithm to calculate this overhead and it is an option whether to include the raw or the calculated timings.
I have one question now - what's a "brown bag"? (its not a common expression this side of the pond :-) / comments
Hi.
Thanks for your question.
Obviously I can't go into too much details about the exact techniques of the application but the general technique is one of IL injection and using the perfomance coun...
I find this solves 80% of all such problems:
Run the Red Gate SQL Backup agent as Local System. Job done. / comments
I find this solves 80% of all such problems:
Run the Red Gate SQL Backup agent as Local System. Job done.
We may, finally, have a definitive answer:
On a 64-bit OS, profiling a web app when IIS is set to 32-bit fails. You get a HTTP 500 internal server error. We think it's loading the 64-bit core into a 32-bit process.
To set IIS to 32-bit mode, run the VBscript command as described here: http://support.microsoft.com/kb/894435 / comments
We may, finally, have a definitive answer:
On a 64-bit OS, profiling a web app when IIS is set to 32-bit fails. You get a HTTP 500 internal server error. We think it's loading the 64-bit core into ...
Sorry for all these problems guys. As some of you have found out - profiling under the development web server usually works much better (the web dev environment is much simpler than IIS- no impersonation, no SSL etc) but we still haven't got to the bottom of the real problem here although it is very likely to do with how applicationHost.config is dealt with). So, my colleague Brian found a way of bypassing this which seems to work well in some case.
Debugging from the top.
Are you using <= .NET 1.1?
Also, is your app pool configured in Integrated Pipeline mode?
We don't seem to do so well with the early frameworks or integrated
pipeline. If its possible, please try a different configuration (e.g. .NET
2.0, classic mode). Otherwise, the workaround is to use a console app that
uses HostableWebCore and treats the applicationHost.config file differently
to ANTS (so if this works, we know that this is the cause of the problem).
Please download it from here
(if you are using .NET 1.1) ftp://support.red-gate.com/Patches/ANTS ... Host11.zip
(otherwise) ftp://support.red-gate.com/Patches/ANTS ... onHost.zip
The original post was here: http://www.red-gate.com/MessageBoard/vi ... t=antsappl
icationhost
ReadMe.txt included in zip file. / comments
Sorry for all these problems guys. As some of you have found out - profiling under the development web server usually works much better (the web dev environment is much simpler than IIS- no imperso...
Hello Jonathan,
no there are no known issues of the memory profiler giving spurious information of this nature. Something is still maintaining a reference to those generic collections. I think you should be able to get a "second opinion" on this simply by loading up those collections with multiple objects and observing the memory usage in Windows task manager.
Hope this helps. / comments
Hello Jonathan,
no there are no known issues of the memory profiler giving spurious information of this nature. Something is still maintaining a reference to those generic collections. I think you ...
Yes, this has been tested and it does work. I think we'd need to see some logs to find out the real cause of the problem.Can you set up logging as per this article please: http://www.red-gate.com/supportcenter/C ... wledgebase\ANTS_Profiler\KB200701000002.htm
(In summary, create a 'logs' folder in the profiler folder and restart the ANTS 3 service, and reproduce the problem) / comments
Yes, this has been tested and it does work. I think we'd need to see some logs to find out the real cause of the problem.Can you set up logging as per this article please:http://www.red-gate.com/su...
Can you test the SVN connection *independently* of Redgate Source Control (through, for example, tortoise SVN)?
It important to know if its a general SVN issue or something caused by our libraries / comments
Can you test the SVN connection *independently* of Redgate Source Control (through, for example, tortoise SVN)?
It important to know if its a general SVN issue or something caused by our libraries