Follow

Connect

To be able to connect you first need a license for accessing your data remotely. to do that, just write to support@soak.dk, and within 48 hours, you will receive an email with Username, password and datashource. Please include the IP address from where you want to have access.

So now you have the license, what to do next? This walk-through is based on Microsoft SQL server Management Studio, but the steps should be the same for other applications (e.g. Microsoft Excel).

1. Open Management Studio

To open the management studio search for Microsoft SQL Server Management Studio or find the Icon

Click on it and Management studio will open.

Note, If you dont have Management studio, then click here to download.

when you have opened the application, it should look like this:

2. Connect

In the connect box enter the information that you received by email:

  1. Servername. remember Port number. IP and port must be seperated by Comma.
  2. Login
  3. Password

After you have entered this, then click Options (if you forget this, then you can't Login) and enter SQLPowerhouse in Connect to database.

Click connect.

If you have succeeded then the object explorer in the left side looks like this:

 

3. Expand Object types (e.g. Views).

Click on databases and Views (or Programmability --> Stored Procedures), and you will see the objects you can query:

(Please note. This list will change over time).

4. Query the data

Right click Data.vStatusWaitsHour and choose Select 1000 rows.

You will  see an autogenerated query and the result. If not, then you have a problem, and you should search our knowledgebase and/or contact support on support@sqlpowerhouse.com.

 

5. Success

If you could query the data, then you have access to your performancedata, and you have setup everything correctly.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.