SQL Server Performance is generally presented early on in a progress cycle when somebody, perhaps not the individual ejects the words of "knowledge". It recommends that performance should be considered while conniving and designing the database, or representing the latest server configuration. But this is not importantly true, as performance is that much important to a small system as it to a large one and also a minute database with 10 users is equally important to those 10 users on small system as to the 10 million users it props up. The goal of the SQL Server Performance is to make available, in broad blows, a position to obtain basic performance information and amendment that employs equally well to SQL Server 2000 or 2005.
While introducing the server and designing, a database are the bases on which performance is constructed. It takes into account the measurement of the performance which further assures and gives the right direction to make future decisions. The two major fields which need to be measured are the
• Performances of the server itself (including both Windows and SQL Server)
• Performances of databases and their allied code within SQL Server.
These two sets of measures need to be combined to truly understand what's happening with your system. There are some tools which perform the measurements of the Windows server, regardless of any server you are running. SQL Server and Windows performance is now frequently measured in the entire industry. For measuring parameters Microsoft allows for Performance Monitor Counters that intends for watching the server.
When you collect the data on your server as a part of load test or during high production use, then you must be known to the valuations of the counters because each set of counters states a unlike part of the story. An enormous amount of access to the lower level is obligatory to describe all of them. As an alternative, a focus on a very few of the most vital counters is crucial to ones that can straightforwardly point to the health of your general system, the Server itself and SQL Server.
For more detail: