Comments
Sort by recent activity
Hello,
It could just be that there is no source code for the method or object that you're currently viewing (depending on if you're doing the memory or performance profiling).
If you look at the 'Source File' column in the results, is there a source code file listed anywhere in there, and if so, does source code appear in the source code pane when you select that object or method? / comments
Hello,
It could just be that there is no source code for the method or object that you're currently viewing (depending on if you're doing the memory or performance profiling).
If you look at the 'S...
Hi Jason,
Thanks a lot for your feedback! SQL Compare 5 used to let you save an image of the schema for the databases that you just compared to snapshot files without having to "register" the database again.
In the latest version, you have to think through things a bit more and create the snapshots using File->Create Snapshot and then compare the two saved snapshots. Of course, this is not ideal as when you go to synchronize, you have to re-register (at least) the target database to update through the program or just output the script to SSMS and then run it from there.
I'll go back and see if there is a legitimate reason why this was taken away from SQL Compare. / comments
Hi Jason,
Thanks a lot for your feedback! SQL Compare 5 used to let you save an image of the schema for the databases that you just compared to snapshot files without having to "register" the datab...
Hi Scott,
The query timeout of SQL Compare is hard-coded at ten minutes.
I think that you may have to manually change the column datatype in the target database in SSMS before running the synchronization. Of course the operation could also timeout in SSMS, too. / comments
Hi Scott,
The query timeout of SQL Compare is hard-coded at ten minutes.
I think that you may have to manually change the column datatype in the target database in SSMS before running the synchroni...
Hi Adam,
I can't see a way of profiling a deployed clickonce application, you will probably be better off profiling it before it's been deployed.
If you use the "install on the computer" option, it should be a matter of opening the program shortcut and using the shortcut program name and arguments in the memory profiler's .NET desktop application settings.
If you make it so your users always have to go through the web browser to run the application, this is a bit more tricky. I have tried a few things to make it work -- one was the obvious:
program: c:\program files\internet explorer\iexplore.exe
arguments: http://localhost/myapplication/my.application
Then the less obvious way of running ClickOnce that I got from reverse-engineering it:
program: c:\windows\system32\rundll32.exe
arguments: dfshim,ShOpenVerbApplication http://localhost/myapplication/my.application
The ClickOnce app launches, but even with the "profile child processes" option turned on, neither ANTS Memory nor ANTS Performance profiler seem to pick up on the .NET app being run by ClickOnce.
I hope that someone more familiar with ClickOnce can chime in on this topic. :-) / comments
Hi Adam,
I can't see a way of profiling a deployed clickonce application, you will probably be better off profiling it before it's been deployed.
If you use the "install on the computer" option, it...
Hi all,
I'm happy to say that you can successfully profile ClickOnce in ANTS Performance Profiler v6 using the earlier instructions:
program: c:\windows\system32\rundll32.exe
arguments: dfshim,ShOpenVerbApplication http://localhost/myapplication/my.application
*where "http://localhost/myapplication/my.application" is the ClickOnce URL.*
This means that you can easily profile clickonce whether or not you have actually chosen to install the application locally. / comments
Hi all,
I'm happy to say that you can successfully profile ClickOnce in ANTS Performance Profiler v6 using the earlier instructions:
program: c:\windows\system32\rundll32.exe
arguments: dfshim,Sh...
This problem should be solved in version 2.6. / comments
This problem should be solved in version 2.6.
Hi Doug,
The assumption that we currently have is that the IL is somehow getting 'scrambled' by the Profiler. We'd found this to happen in some specific applications before and applied a fix for it, which is why the thread had been closed out.
It would be fantastic if we could get a small code sample, or a snippet of code that causes this exception to be thrown. Do you have any code you can send? If you'd like, you can send it to our support email address. / comments
Hi Doug,
The assumption that we currently have is that the IL is somehow getting 'scrambled' by the Profiler. We'd found this to happen in some specific applications before and applied a fix for it...
Hi Doug,
Thanks for sending us the code. We can, in fact, reproduce the problem reliably here. I suspect it's the custom COM wrappers that you've got which are causing the problem.
We have an updated CORE component that we are testing that will solve the problem. I'll send the component to you when we're sure that it's 100% functional. / comments
Hi Doug,
Thanks for sending us the code. We can, in fact, reproduce the problem reliably here. I suspect it's the custom COM wrappers that you've got which are causing the problem.
We have an updat...
Hi Jason,
Thanks for your post. Either I don't understand the problem correctly or haven't gone through the same steps as you have, but I cannot reproduce the issue.
I have the following schema collection:
CREATE XML SCHEMA COLLECTION [dbo].[SQLCompareReport]
AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" ...
CREATE TABLE [dbo].[SQLCompareReports]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[filename] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[report] [xml] (CONTENT [dbo].[SQLCompareReport]) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
In the documentation for the XML Schema Collection "SQLCompareReport", the "used by" section reports [dbo].[SQLCompareReports].
If you have some script that will reproduce the issue, or if maybe the database is actually operating in compatibility mode 80, please let me know. / comments
Hi Jason,
Thanks for your post. Either I don't understand the problem correctly or haven't gone through the same steps as you have, but I cannot reproduce the issue.
I have the following schema col...
exec master..sqlbackup '-SQL "RESTORE DATABASE [msdb] FROM DISK=[c:\backups\file.sqb] WITH PASSWORD=''password'', REPLACE"' / comments
exec master..sqlbackup '-SQL "RESTORE DATABASE [msdb] FROM DISK=[c:\backups\file.sqb] WITH PASSWORD=''password'', REPLACE"'