Microsoft SQL Server Performance Monitoring and Tuning

Email Alerts

Register now to receive news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SQL Server 2012 ‘virtually’ out, Microsoft talks features, licensing

    With SQL Server 2012 released in a “virtual launch” this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are. 

  • Microsoft bulks up SQL Server scalability to rival buff competition

    Better SQL Server scalability and lower costs have furthered Microsoft’s reach in recent years, industry observers say, and that’s good, because the competition is big and knows the turf well. 

  • SQL Server BI performance for the uninitiated

    Maintaining a SQL Server business intelligence (BI) system may be challenging for many database administrators, but there’s a lot you can do to ensure top SQL Server BI performance. 

  • Microsoft gives tour of new release of SQL Server

    Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features. 

  • Q&A: Create and tune indexes in SQL Server 2000

    DBAs can build a SQL Server index best designed for their database environments by learning about columns, clustered indexes, and more. 

  • Minding the data and databases

    The role of the database administrator can be broad or delineated by specialization. DBAs are constantly at the mercy of the project size, scope and application complexity. 

  • Q&A: Making the jump to 64-bit SQL Server 2005

    Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the... 

  • SQL Server 2000 indexing dos and don'ts

    In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec outlines best and worst practices for indexing in SQL Server 2000. 

  • Tool vendor boosts SQL Server, Oracle support

    Embarcadero Technologies Inc. is extending support of its management tool to Microsoft SQL Server and Oracle 10g. Through a single console, DBAs can access and manage DBMSes from multiple vendors. 

  • database mirroring

    Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that might otherwise result from data corruption or loss, or when the operation of a network is partially c... 

  • contiguous

    Contiguous describes two or more objects that are adjacent to each other. 

  • hybrid online analytical processing (HOLAP or Hybrid OLAP)

    Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP). 

  • hashing

    Hashing is the transformation of a string of characters into a usually shorter fixed-length value or key that represents the original string. 

  • drilldown

    As currently used in information technology, to drill down (verb) is to focus in on something. 

  • contiguity

    Contiguity (from Latin contiguus and contingere, to have contact with) is the state of being in close proximity with or even touching another object. 

About Microsoft SQL Server Performance Monitoring and Tuning

From testing and monitoring to indexing and troubleshooting, you're sure to find a resource to help resolve your Microsoft SQL Server performance problems. To ensure your SQL Server databases and applications run at their full potential, you must continually identify performance problems and quickly address bottlenecks. This page features resources covering all aspects of SQL Server performance and tuning, with details on debugging applications, optimizing database performance and more. Also, be sure to check out our recent tutorials on SQL Server performance tuning via indexes and queries.