Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Optimization Rss

Search for any content tagged optimization

   Items 1 to 4 of 4   
 

Reporting Services Performance and Optimization

This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.  Read more...
By Additional Articles 2013/12/24 | Source: SQLCAT | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,000 reads

Stairway to Transaction Log Management in SQL Server Level, 8: Optimizing Log Throughput

This level takes a deeper look at how log fragmentation can affect the performance of operations that need to read the log, such as log backups, or the crash recovery process.  Read more...
By Gail Shaw, Tony Davis 2013/04/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,994 reads

Optimal Storage of IP addresses in a SQL Server database

Often databases are used with web-based interfaces and recording the IP address of the end user can assist with debugging, marketing, bandwidth planning and collation selection to name a few. In a scenario where each page access is logged, is there an optimal way to store IP addresses?  Read more...
By Additional Articles 2011/12/07 | Source: MSSQLTips.com | Category: ip addresses
Rating:  Rate this |   Briefcase | 3,391 reads

Optimize a SQL Server Analysis Services Measure Group Partition for Performance

In this tip you will learn how to design aggregations for a partition and optimize it for performance. Solution  Read more...
By Additional Articles 2011/08/26 | Source: MSSQLTips.com | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,620 reads
   Items 1 to 4 of 4