flatlining my desktop

Easy unit testing for databases in SQL Server Management Studio

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, David Priddle

flatlining my desktop

Postby dschlobohm » Fri Apr 12, 2013 1:53 pm

using ssms 10.5 i have noticed that if i click on SQLtest that it use 30 percent of my desktop cpus regardless if anything is running

I like to use different ssms for different projects so as you can see it flatlines my desktop quickly. I has also notice that if i turn off SQL test this doesnt fix the problem you have to get out of SSMS and back in
dschlobohm
 
Posts: 3
Joined: Fri Apr 12, 2013 1:37 pm

Postby james.billings » Mon Apr 15, 2013 5:54 pm

Thanks for your post
This isn't something we're aware of that I know of- does it happen irrespective of which SQL instance you're connected to?

Does it occur simply by pressing the SQL Test button so the window appears (i.e. you've not added any tests to any databases yet) or is it when you run the tests themselves?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby dschlobohm » Mon Apr 15, 2013 6:30 pm

Just by pressing the SQL test the window opens the utilization goes up
You exit the window or press the button to turn SQL test off the utilization hits 30 percent and stays there until I exit SSMS. No test is running just sits there spinng cpu's
dschlobohm
 
Posts: 3
Joined: Fri Apr 12, 2013 1:37 pm

Postby james.billings » Mon Apr 15, 2013 6:36 pm

Pretty unusual then. Do you have any other (non Red Gate) SSMS add-ins installed?

One option may be to try downloading a trial of our ANTS Performance Profiler, and profiling SSMS. This might show whereabouts in the execution excessive CPU is occurring.
If that works, you can save the results, zip them, and mail them to support@red-gate.com quoting F0071759 in the subject line.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Test

Who is online

Users browsing this forum: No registered users and 0 guests