cancel
Showing results for 
Search instead for 
Did you mean: 

How to measure SQL hits due to my application

Highlighted
Community Hero

How to measure SQL hits due to my application

Use case:

 

I'm working on a form in development environment and everything works fine. aqPerformance tells me everything is quick.  I make a change in my form.  aqPerformance still tells me everything is quick.  Users suddenly report that everything has slowed down and the system is unusable and they want me to personally drive over to their offices and make coffee while they wait for the form to load.  After testing, I find that the small change in my form suddenly added 200 SQL queries each time you move your mouse.  This isn't a problem in production or our test servers, but the users are on a network with high latency.  Each single SQL connection is quick, but it adds up.

 

Is there a way to monitor these SQL hits by, say, using profiler and profiling during the form load/ item select etc. then report back the amount of SQL queries ?  I know developers could keep profiler open while developing the application, but sometimes it doesn't behave the same on you machine as on live and you want to know if something has dramatically changed.  Also, if you could catch this before it gets to users that would save alot of fuel.


-------------------------------------------------
Standard syntax disclaimers apply
Regards,
6 REPLIES 6
Highlighted
Community Hero

Re: How to measure SQL hits due to my application

I'm not sure whether or not there exists any sort of SQL profiler integration in TestComplete.  So, if anything, you would need to automate interacting with the profiler tool itself.

AQTime, however, might have the ability of doing these kinds of profiling tasks and it DOES integrate with TestComplete.

 

Check out https://support.smartbear.com/testcomplete/docs/working-with/integration/aqtime/index.html


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
Community Hero

Re: How to measure SQL hits due to my application

I've had a quick look at it - and attended AQTime training academy 101 Smiley Tongue I can see that it would allow me to look at performance on a global scale.  It's big on the application side, but I don't see much on the SQL side.  I can't see any indication that it would be able to do someting like error my test if SQL performs more than X queries between the button click and the page being ready after the click.  Any experience that would confirm or deny my limited exposure to help me decide if I should use AQTime or write some sort of custom server side profiling scripts (I've got an idea involving stored procedures, xml files,SQL built-in functions and a touch of roasted fennel to make that work...). I'd prefer the former, but would be prepared to do the latter.  I just need input before I go and do redo something TC/AQTime can already do


-------------------------------------------------
Standard syntax disclaimers apply
Regards,
Highlighted
Community Hero

Re: How to measure SQL hits due to my application

There is an AQTime community 

 

https://community.smartbear.com/t5/AQtime/ct-p/AQTime

 

Perhaps ask there?


Robert Martin
[Hall of Fame]
Please consider giving a Kudo if I write good stuff
----

Why automate?  I do automated testing because there's only so much a human being can do and remain healthy.  Sleep is a requirement.  So, while people sleep, automation that I create does what I've described above in order to make sure that nothing gets past the final defense of the testing group.
I love good food, good books, good friends, and good fun.

Mysterious Gremlin Master
Vegas Thrill Rider
Extensions available
Highlighted
Community Hero

Re: How to measure SQL hits due to my application

You are welcome to set a performance counter on litterally hundreded of different database based profilers in TestComplete, from connections to latency to commits, etc...

choose Performance counters and select Custom Profilers, go down the list and see the hundreds of different profilers available for SQL Server that are running on your Machine.

I also use Red Gate SQL Profilers, they are very good with great User Interface

AQTime, will do the job as well, I have used it in the past to do SQL Profiling but it is not as easy to use as Red Gate SQL profiler.

 

 

Cheers

-Lino

Community Hero

Re: How to measure SQL hits due to my application

Thanks, I'll ask.  I'm just genuinely surprised that nobody else has wanted to measure this in the middle of test runs Smiley Surprised

 

Just putting in a timer checkpoint can't tell me if a code change is going to kill a SQL server with redundant/multiple calls to the database.  Our application by neccesity has to share a SQL server with other applications and there are too many instances of "Your software made all our other software break" to ignore this.


-------------------------------------------------
Standard syntax disclaimers apply
Regards,
Highlighted
Community Hero

Re: How to measure SQL hits due to my application

@LinoTadros 

 

Even if AQTime does what I need, it will probably be a hard sell.  Another software package like Red Gate would be nice, but not jusifiable for our company just yet Smiley Happy


-------------------------------------------------
Standard syntax disclaimers apply
Regards,
New Here?
Join us and watch the welcome video:
Announcements
Join TechCorner Challenge!
Want a fun and easy way to learn TestComplete? Try solving weekly TechCorner challenges and get into the Leaderboard!


Challenge Status

Compare images using the Region Checkpoint

See replies!

Converting UTC TimeDate in an Excel file

See replies!

Compare HTML table with Excel file and correct data in Excel file

Participate!

How to execute remote test and obtain results via Test Runner REST API

Participate!
Top Kudoed Authors