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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...