Jump to content
WAPT Forum
Sign in to follow this  
hjanweja

Measure SQL Performance

Recommended Posts

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 !

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×