i dont know how to measure the sql server performance...

• Aldo Zavala

  Mr or Mrs. 500

  Points: 507

  More actions

  June 26, 2006 at 12:28 pm

  #70906

  hi, whats the tool you recommend me for analyze the performance and the query time, queries per seccond of the sql server?

  thanks in advance

  Aldo

• John Rowan

  SSC Guru

  Points: 56440

  More actions

  June 26, 2006 at 1:38 pm

  #645912

  Well, there are many tools and methods that you can use to look at SQL Server performance.  There are many performance related articles on SSC and also on http://www.SQLServerPerformance.com.  Much of what I do depends on the type of performance problem that I encounter.  Are you having a specific performance problem?

  John Rowan

  ======================================================
  ======================================================
  Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

• Aldo Zavala

  Mr or Mrs. 500

  Points: 507

  More actions

  June 26, 2006 at 1:41 pm

  #645913

  no, i think im not, but since i linked an access db into my sql, and i would like to query it hard... i would like if it reduced my performance or some

• NielsGrove

  Say Hey Kid

  Points: 710

  More actions

  August 3, 2006 at 12:17 am

  #652998

  In the Microsoft SQL Server 2000 Operations Guide - which can be downlaoded from this URI: http://www.microsoft.com/TechNet/prodtechnol/sql/2000/maintain - there is a suggestion for a baseline in chapter 5 at page 9.

  /Niels Grove-Rasmussen