Browse Blog Posts by Tags

All Tags » performance » best practices (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Analysis Services database and OLAP systems: building and tuning for the best possible performance

When it comes to performance tuning there is no magic wand or short cut to wipe out the issue. The process is a constant learning and primary step is to ensure no issues are occuring repeatedly, which means you are not utilizing the time to reduce the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 17 2011
Filed under: Filed under: sql server, performance, analysis, best practices, monitoring, cube, benchmarking, performance tuning, performance guide, scalable
Take the offer on SQL Server 2008 R2 Administration cookbook and SQL Server 2008 R2 Master Data Services

In continuation to the Packt Publishers September offer on Microsoft books I would like to promote two essential books to upgrade your knowledge in Microsoft SQL Server 2008 R2 technologies. Microsoft SQL Server 2008 R2 Administration Cookbook Over 70...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Sep 7 2011
Filed under: Filed under: sql server, performance, dba, best practices, disaster recovery, publisher, books, performance monitoring, ebook, beginners in sql serever, offer, master data services, packt
SQL Server Performance series: TEMPDB.. monitoring and troubleshooting practices #sql #sqlperf #tempdb

The global resource for a SQL Server system is TEMPDB, because it holds all the information pertaining to temporary user objects, internal objects used by SQL engine, row versioning for data modifications and any ad hoc TSQL execution results. Since SQL...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jun 8 2011
Filed under: Filed under: sql server, perfmon, performance, dba, best practices, table, troubleshoot, tempdb, monitoring, benchmarking, performance monitoring, counters
SQL Server performance practices: Max Worker Threads, don't touch it #sql #sqlperf

When you are dealing with multi-instances and multiple databases then handling server resources is essential. By default every instance of SQL Server runs as a seperate system process, in terms of memory. In such cases each instance will need to handle...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 10 2011
Filed under: Filed under: sql server, package, performance, memory, dba, i/o, best practices, maintenance, cpu, max worker threads, performance monitoring, pressure
SQL Server optimization series - query recompilation gotchas

What causes the query to recompile? Is it a good sign or bad sign for performance? How frequently should I recompile the stored procedures? Does a reindex cause SP to recompile when it is executed next time? These are quick questions raised in the recent...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Apr 5 2011
Filed under: Filed under: sql server, performance, optimization, best practices, stored procedure, query plan, recompile, benchmarking, statiscs age
SQL Server Analysis Services: Multi-level hierarchy dimension design gotchas

Dimension design is an important aspect to build the Business Intelligence around the data within the data platform. Just on bascis, on OLAP world the database dimension is treated as colleciton of related objects (referred as attributes) that can provide...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Mar 25 2011
Filed under: Filed under: sql server, performance, memory, dba, attributes, best practices, dimension, cpu, wizard, cube, benchmarking, diagnose
SQL Server virtualization - Hyper-V and Live Migration, interesting concept for server consolidation

Virtualization is a hot topic to discuss and essentail to consider when you are referring to server consolidation to save physical sprawl & costs. The consolidation project will typically start to achieve the mile-stones such as reducing the operations...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 16 2011
Filed under: Filed under: sql server, performance, memory, best practices, enterprise, consolidation, virtualization, scalability, data center, live migration
The backup cannot be performed because 'COMPRESSION' was requested after the media was formatted with an incompatible structure.

This is a new error associated to BACKUP related issues and to be specific first time on this environment. There was no setting of BACKUP COMPRESSION enabled on the SQL 2008 instance which is used by a 24/7 application, by default after the installation...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Oct 11 2010
Filed under: Filed under: sql server, performance, dba, best practices, compression, code, media, backups, setup, sp_configure
SQL Server DMVs - where to start and how to use?

When you need to troubleshoot a problem, prior to SQL Server 2005 you have to depend upon PROFILER or query system tables constantly or some other means to trace the system usage. SQL Server 2005 onwards DBAs are equipped with Dynamic Management Views...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 13 2010
Filed under: Filed under: sql server, performance, memory, dmv, dba, best practices, disk space, troubleshoot, system, resource, beginner, performance tuning
Cumulative update package 9 for SQL Server 2008 Service Pack 1

Download and test the latest instalment of cumulative Update 9 for SQL Server 2008 Service Pack 1 which consist the hotfix release related to SQL Server 2008 version and fix to the issues since the release of Service Pack 1. The build number for this...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jul 22 2010
Filed under: Filed under: sql server, package, performance, release, best practices, ctp, testing, deadlock, trace flag, cumulative update
SQL Server in Virtual platform - keep a close watch on physical server's configuration

Server consolidation & virtualization is a hot topic and also it is one of the biggest concerns for many DBAs is scalability/performance when it comes to virtualization. At this point,performance for virtual machines can be close to, if not the same...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Apr 29 2010
Filed under: Filed under: sql server, performance, memory, dba, i/o, disk, best practices, virtual, cpu, partition, configuration, Hyper-V
SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

This is a every DBA's nightmare to see if they have been alerted, yet another IO related post I would like to talk on explanation & resolution. Error 824 error indicates that a logical consistency error was detected during a read. A logical consistency...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Apr 23 2010
Filed under: Filed under: sql server, performance, search, dba, best practices, error log, recovery, monitoring, dbcc checkdb, reads, beginner, extended, torn page
SQL Server I/O affinity and Snapshot backups - speed up the maintenance activity on your database

Back in SQL Server 2000 version days (I think) SP1 onwards the affinity mask configuration option has been introduced, which refers to IO_affinity_mask_switch using SP_CONFIGURE statement. I/O affinity dedicates special, hidden schedulers to performing...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Apr 22 2010
Filed under: Filed under: sql server, performance, backup, snapshot, best practices, san, monitoring, configuration, vdi
SQL Server SSIS package performance series - resolve the low-memory conditions

SSIS Packages are integral part of database management activities, that all ETL based activities can be managed efficiently. The primary usage for these packages is to manage the movement of data from one place to another. To do that, the package needs...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Apr 21 2010
Filed under: Filed under: sql server, package, perfmon, performance, ssis, ssas, access, best practices, benchmarking, low memory
SQL Server Manageability - Choose Analysis Services database backup strategy

Until SQL Server 2005 performing a backup of Analysis Services database was a troublesome, not like DB engine database backup statements. As said above 2005 version onwards the backup and restore operations are an integral part of the Analysis Services...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Apr 2 2010
Filed under: Filed under: sql server, performance, databases, backup, best practices, Analysis Services, command line, rolap, molap, holap, benchmarking, aso
Hyper-V: Top 3 Reasons people choose to use dynamically expanding storage

Save Space on Primary and Backup Storage. Hyper-V 2008 R2 boasts 87% of native drive system performance. They are separating out the data that is fixed from the information that changes by creating a new location for transitional data. The size of this data is unknown. Jeff Loucks Available Technology

Posted to Winrox - Architecture of Acceleration(TM) by jeffl on Thu, Sep 10 2009
Filed under: Filed under: Architecture, Best Practices, Performance, Hyper-V R2, Dynamically Expanding Storage
The Numbers: Hyper-V R2 and Dynamically Expanding Storage Performance

The Virtualization team is reporting 87% of native performance when using Dynamically expanding drives. A number of MVPs were emailing today about best practices for High Availability using Hyper-V and Clustered Shared Volumes. A great topics in and of itself but one that I will bring forward more extensive...

Posted to Winrox - Architecture of Acceleration(TM) by jeffl on Thu, Sep 10 2009
Filed under: Filed under: Architecture, Best Practices, Performance, Hyper-V R2, Dynamically Expanding Storage
SQL Server performance problem, how bad it is or rather I ask how good are you to find the root cause?

I always trust how good your resources are to find out a root cause than how bad the problem is? It is one of the best point of disaster recovery position I wanted to be to get to work on solution on quicker basis than worrying about the impact, the business...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jul 27 2009
Filed under: Filed under: sql server, perfmon, performance, ssms, tools, best practices, encryption, locks, baseline, benchmarking, performance monitoring
Do you know how many Monitoring Tools and Resources available in SQL Server?

Monitoring Tools and Resources are essential for performance tuning & better manageability in SQL Server. Many times the users think that collection and analysis of performance data is not a day-to-day job, also I feel that it is difficult at best...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jun 1 2009
Filed under: Filed under: sql server, performance, ssms, tools, best practices, bids, monitoring, resources, readtrace, profiller
Proactive caching for Analysis Services databases - performance techniques and better usage

By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, May 31 2009
Filed under: Filed under: sql server, performance, data, cache, best practices, cube, Analysis Services, rolap, molap, proactive, advantage

Page 1 of 2 (38 items) 1 2 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.