SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Performance testing Rss

Search for any content tagged performance testing

   Items 1 to 7 of 7   

Clean Your Buffers for Accurate Performance Testing

In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run.  Read more...
By 2017/04/06 | Source: Database Journal | Category: performance testing
Rating:  Rate this |   Briefcase | 3,170 reads

Executing Multiple Threads to Create a Load

Learn a few techniques for executing multiple sets of queries at once.  Read more...
By Steve Jones 2016/08/11 | Source: SQLServerCentral.com | Category: performance testing
Rating: |  Discuss |   Briefcase | 2,174 reads

What do you consider important when performance testing?

What data specific considerations do you make when preparing for performance testing?  Read more...
By Gary Varga 2014/08/07 | Source: SQLServerCentral.com | Category: performance testing
Rating: |  Discuss |   Briefcase | 215 reads

The Performance of Traversing a SQL Hierarchy

Dwain Camps shows that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can each be the fastest at some point. He illustrates the danger in generalizing from just one set of test data, and that it's foolish to assume that just because SQL code looks neat, it will perform well.  Read more...
By Additional Articles 2014/05/14 | Source: SimpleTalk | Category: performance testing
Rating: (not yet rated)  Rate this |   Briefcase | 2,596 reads

Getting Started with Columnstored Index in SQL Server 2014 – Part 2

Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of the earlier limitations. In this article, Arshad Ali discusses how you can get started using the enhanced columnstore index feature in SQL Server 2014 and do some performance tests.  Read more...
By Additional Articles 2013/11/06 | Source: Database Journal | Category: columnstore index
Rating: (not yet rated)  Rate this |   Briefcase | 4,325 reads

Method to the Madness

Instead of piling on more, often increasingly complex, tools, Tony believes what is needed is a clear roadmap and methodology for systematically addressing SQL Server Performance issues.  Read more...
By Tony Davis 2009/05/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 140 reads

Performance Testing SQL 2008’s Transparent Data Encryption

The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?  Read more...
By Additional Articles 2009/04/28 | Source: Database Journal | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,585 reads
   Items 1 to 7 of 7