Jump to content


Photo

Measure SQL Performance


  • Please log in to reply
2 replies to this topic

#1 hjanweja

hjanweja

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 29 October 2013 - 09:16 PM

Hi Experts,

Am currently evaluating the tool, have a question on the counter for SQL performance.
It asks me for 3 params, the DSN, the user and password.

Lets say my DB name is 'TESTDB' and the user is 'abc' and password is 'test'. Lets say this DB is not on my localhost but is on another server with IP 10.0.10.10

In that case what are the values I should add to the above fields for the test to pass, currently it says, 'Data source name not found and no default driver specified'

Many thanks !

#2 Sergei Leonov

Sergei Leonov

    Advanced Member

  • Administrators
  • PipPipPip
  • 662 posts

Posted 30 October 2013 - 03:22 AM

You need to create ODBC connection first.
You can find more info in the online help:
Note that a specified DSN should be added to the list of ODBC User Data Sources beforehand. For this, you should enter the Windows Start menu, select Control Panel | Administrative Tools | Data Sources (ODBC) and add a desired User Data Source. Then you will be able to use that data source in the DSN field of the Performance Counters view.
Sergei Leonov
WAPT Project Manager
SoftLogica LLC

Office: +7-383-335-6692
Toll-free: 1-888-364-6797 (for US only)
Time zone GMT +6, EST +11
E-mail: support@loadtestingtool.com
http://www.loadtestingtool.com

#3 hjanweja

hjanweja

    Newbie

  • Members
  • Pip
  • 8 posts

Posted 30 October 2013 - 06:28 PM

Thanks, this works !




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users