User profile for Chris.Allen

Hot off the press! We think we know what causes the crash now and have made a private build. I'll email it to anyone who emails support with their ANTS log file (will email you soon Doug). / comments

Hot off the press! We think we know what causes the crash now and have made a private build. I'll email it to anyone who emails support with their ANTS log file (will email you soon Doug).

0 votes

I echo Brian's statement- best thing to do is obtain a mini-dump so we can get the full stack trace at the time of teh crash and we'll analyse it using our debug symbols. Please mail: support@red-gate.com Thank you. / comments

I echo Brian's statement- best thing to do is obtain a mini-dump so we can get the full stack trace at the time of teh crash and we'll analyse it using our debug symbols. Please mail: support@red-g...

0 votes

All these issues sounds like .NET crashes. Please see both these articles about how to prevent certain types of crashes (apply both fixes if necessary) http://www.red-gate.com/supportcenter/C ... spx?p=ANTS Memory Profiler&c=knowledgebase%5cANTS_Memory_Profiler%5cKB200907000416.htm http://www.red-gate.com/supportcenter/C ... spx?p=ANTS Memory Profiler&c=knowledgebase%5cANTS_Memory_Profiler%5cKB200908000419.htm / comments

All these issues sounds like .NET crashes. Please see both these articles about how to prevent certain types of crashes (apply both fixes if necessary)http://www.red-gate.com/supportcenter/C ... sp...

0 votes

Did you by any chance ever install "YourKit"? That program does cause conflict with ANTS- especially regarding environment variables. Can you try checking your registry to see if the environment variable COR_PROFILER is enabled for the ASPNET user? First, try checking the default environment settings using regedit in HKEY_USERS\.Default\Environment to see if COR_PROFILER is set. Next, check to see if the ASPNET account has its' own environment settings. I don't think it will unless it's logged in interactively. To check this, you'd need the ASPNET account's SID, which you can get by saving the following VB code to a file and running with cscript.exe: Code: 'VBScript to Enumerate Accounts, and SID On Error Resume Next if Err <> 0 Then set lasterr = CreateObject("WbemScripting.SWbemLastError") Wscript.echo lasterr.Operation End if 'Get the local machine name set WshShell = WScript.CreateObject("WScript.Shell") SET WshEnv=WshShell.Environment("PROCESS") Dim Machinename Machinename=WshEnv("COMPUTERNAME") set objWMIService = GetObject("Winmgmts:\\" & Machinename) set colAccounts = objWMIService.InstancesOf("win32_Account") For each objAccount In colAccounts If objAccount.name="ASPNET" AND objAccount.Domain=Machinename Then WScript.echo "Name " & objAccount.name & vbCRLf & _ "SID : " & objAccount.SID & vbcrlf & _ "Sid Type : " & objAccount.SIDType & vbcrlf & _ "Status : " & objAccount.Status & vbcrlf & _ "Domain : " & objAccount.Domain & vbcrlf & _ "Caption : " & objAccount.Caption End if Next WScript.quit Check HKEY_USERS\<SID>\Environment and see if COR_PROFILER appears in there. When we need to profile services (such as IIS), we usually edit the service environment to contain the variables necessary to hook ANTS in. We added some code in a recent version that also changes the permissions on the temp directory to allow the UI and the service to read and write the same files (which is required for profiling), which has caused some issues for some people. For IIS 5 we change the variables for the user that ASP.NET is running as, due to the different way it starts up. It's usually not critical when the variables get left behind, as the core will disable itself if it's loaded into an application that doesn't need to be profiled. When the Core DLL is installed, we register it with COM+, and we unregister it when the profiler is uninstalled. Apart from that we don't make any changes to the system that could become permanent: for plain old desktop apps there's no need to change the registry to get the profiler to load in. / comments

Did you by any chance ever install "YourKit"? That program does cause conflict with ANTS- especially regarding environment variables. Can you try checking your registry to see if the environment va...

0 votes

We now have two workarounds for crashes: 1. What we have found that works is disabling the server garbage collector as described here: <http://support.microsoft.com/kb/911716> Remember- "server GC" actually means multi-core GC. 2. Parametize your main method with: [System.LoaderOptimization(LoaderOptimization.MultiDomain)] or [System.LoaderOptimization(LoaderOptimization.MultiDomainHost)] If you don't have a main method, for example: if you have a WPF project, take a look at this article which shows you how to do it: http://www.matthidinger.com/archive/200 ... ation.aspx / comments

We now have two workarounds for crashes: 1. What we have found that works is disabling the server garbage collector as described here: <http://support.microsoft.com/kb/911716> Remember- "server ...

0 votes

Hi Matthew, you always have to install ANTS on the same machine as application you are profiling (the .NET profiling API has no remote capability) but, of course, you can still "drive" a session remotely (using RDP etc.) I hope this helps. / comments

Hi Matthew, you always have to install ANTS on the same machine as application you are profiling (the .NET profiling API has no remote capability) but, of course, you can still "drive" a session re...

0 votes

I'm just wondering if it would help to use SQL Compare to ensure the structures are sufficiently similar to allow Data Compare to work. Use a trial version if you don't have a copy already. We generally recommend to only apply a data sync over a compare sync. / comments

I'm just wondering if it would help to use SQL Compare to ensure the structures are sufficiently similar to allow Data Compare to work. Use a trial version if you don't have a copy already. We gene...

0 votes

Its not a fault, as such - its just that default filters are being applied. Try de-selecting the "Hide Insignificant methods" check box. / comments

Its not a fault, as such - its just that default filters are being applied. Try de-selecting the "Hide Insignificant methods" check box.

0 votes

Just to say - if you can get that information, please send it to support@red-gate.com (with subject: F0025768). I have opened a support ticket for this already. / comments

Just to say - if you can get that information, please send it to support@red-gate.com (with subject: F0025768). I have opened a support ticket for this already.

0 votes

Could you please run: SELECT CAST(0 AS INT) AS ColumnPermissionID, sp.grantee_principal_id as uid, su.name AS UserName, OBJECT_NAME(sp.major_id) AS ObjectName, SCHEMA_NAME(so.schema_id) AS ObjectOwner, 1 AS class, sp.type, sp.state, so.type AS ObjectType, CONVERT(int, null) as columns FROM sys.database_permissions AS sp WITH (NOLOCK) INNER JOIN sys.sysusers su WITH (NOLOCK) ON su.uid=sp.grantee_principal_id INNER JOIN sys.objects so WITH (NOLOCK) ON so.object_id=sp.major_id WHERE sp.major_id>0 AND sp.class = 1 AND sp.minor_id = 0 AND (sp.type in ('IN','DL','EX') OR CHARINDEX(sp.type, 'CRFNCRTBCRDBCRVWCRPRBADBCRDFBALOCRRU')%4 > 0) AND so.schema_id IS NOT NULL AND sp.type='VWCT' GROUP BY sp.major_id, sp.grantee_principal_id, sp.grantor_principal_id, sp.type, sp.state, so.type, su.name, so.schema_id If anything is returned, the problem is that in SQL 2008, we do not support the View Change Tracking user right. / comments

Could you please run: SELECT CAST(0 AS INT) AS ColumnPermissionID, sp.grantee_principal_id as uid, su.name AS UserName, OBJECT_NAME(sp.major_id) AS ObjectName, SCHEMA_NAME(so.schema_id) AS ObjectOw...

0 votes

How can we help you today?

Chris.Allen

Comments