Problem with new version 491

• 
  When I looked to see how far the application profiling got, my application is hanging in the following code when the profiler is running:
  

  Dim cn As System.Data.SqlClient.SqlConnection '=
          ' Clear out any old error messages
          DBErrorMsgs = ""
  
          ' Define the connection
          ' Dim cn As OleDbConnection
          Dim SQL1 As String
          Dim cmd As System.Data.SqlClient.SqlCommand
  
          ' Assume we cannot access the database
          ValidateDBAccess2 = False
  
          ' Set up the connection string
          sConnString = "Data Source="
  
          ' Add the database server name
          If sServerName = "" Then
              sConnString = sConnString + "(local)" + ";"
  
          Else
              sConnString = sConnString + sServerName + ";"
          End If
  
          ' Set the initial database name
          sConnString = sConnString + "Network Library=DBMSSOCN;Initial Catalog=ToysToTrack;"
  
          ' Try using integrated security
          sConnString = sConnString + "Integrated Security=SSPI;"
  
          Debug.Print("Connection string: " + CStr(sConnString))
  
          Try
              ' Open the connection and try to do a simple DB operation
              cn = New System.Data.SqlClient.SqlConnection(sConnString)
  

  (Code never executes past the time that the database connection is attempted. Code works fine without the profiler.)
  
  Any ideas?
  
  Thanks,
  
  Rick

  rkamp July 06, 2008 02:54

  - 0 +
• 
  Hi Rick,
  
  Thanks for your post. We haven't seen this happen before and are having trouble replicating the issue. Our test applications run database related code fine.
  
  is there an exception being thrown in your code?
  
  I was also wondering if your application is multi-threaded. There's a chance that with the profiler attached it's slowing your code so that you are seeing the result of a race condition that you wouldn't normally otherwise see. Although this is a much lower probability.
  
  You could also try attaching the Visual Studio debugger to your application while it's being profiled and it should still work. If you hit pause you should be able to see exactly where the application has stopped.
  
  The more info you can give the better.
  
  Thanks,
  
  Stephen

  StephenC July 07, 2008 05:22

  - 0 +
• 
  I have taken some of the initialization code in my app and created a simple project which works sometimes with the 4.491 release, but most times the app just hangs when it is trying to open the database connection. My real app doesn't get through the Load routine in the main form.
  
  For the 3.2 release, the program just hangs and the main form never appears.
  
  This is a VS 2008 (SP1) VB application running on Microsoft Server 2003.
  
  In either case, I would appreciate your opinion on why this code doesn't work with your tool.
  
  I have emailed the source code to the support@red-gate.com email address.
  
  Thanks,
  
  Rick Kamp
  Kamp Consulting Services

  rkamp July 08, 2008 03:24

  - 0 +
• 
  Thanks for that Rick,
  
  the files you sent have been gone over and we cannot get the issue to appear with ANTS 4 in any environment at all. We have tried it multiple times under various scenarios and it works each time with our Debug and Release versions of the ANTS 4.
  
  We have filed the issue and will continue to try and replicate it but if we cannot replicate the issue then a potential fix may not be forthcoming any time soon.
  
  Regards,
  
  Stephen

  StephenC July 08, 2008 11:36

  - 0 +
• 
  Stephen,
  
  Thanks for taking a look at this. My development machine is Windows 2003 Server and is where I'm having the problem. If I run your program on my Windows Vista machine (SP1), everything seems to run fine and I can profile my application without problems.
  
  If I find some more information about this issue, I'll let you know, but for now I'll do my testing on Windows Vista.
  
  I'm really excited about the 4.0 release. The user interface is great!
  
  Cheers,
  
  Rick

  rkamp July 08, 2008 12:59

  - 0 +
• 
  Glad you like the new UI. A new build will be released in a couple of days time with additional features such as some performance counter selection and individual thread selection will be available. I'll drop you an email to let you know.
  
  Can I quickly ask regarding the new Call Graph feature - what the use case(s) might be for you regarding this feature?
  
  Thanks,
  
  Stephen

  StephenC July 08, 2008 13:07

  - 0 +
• 
  Hi Rick, just a quick question. Are you connecting to Windows 2003 via a remote desktop connection? ANTS Profiler has an issue when connecting to RDC sessions that are not console sessions.

  JasonC July 08, 2008 13:18

  - 0 +
• 
  Stephen,
  
  In most cases I'm getting to the server via a Terminal Services connection.
  I have tried running locally on the console, and still have the same problem.
  I'm going to try running with the database connected locally instead of using a remote database. I'll let you know the results.
  
  As far as the Call Graph, it does a good job about showing the most expensive calls. The drill down is very good, too. If I need more detail, I just look at the individual lines of code to see the timings. What toolkit are you using to display the graph? It is a very nice tool for your application.
  
  Rick

  rkamp July 08, 2008 13:24

  - 0 +
• 
  It's all custom drawn but we use yFiles for the layout algorithm at the moment.
  
  Export options are coming soon.
  
  Stephen

  StephenC July 08, 2008 13:41

  - 0 +

Add comment

Please sign in to leave a comment.