Browse Blog Posts by Tags

All Tags » Best Practices » multiple (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

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

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 6 2010
Filed under: Filed under: sql server, memory, server, best practices, sharepoint, installation, multiple, cpu, resources, configuration, powerpivot
SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 28 2009
Filed under: Filed under: sql server, best practices, multiple, table, storage, tempdb, create, files, performance monitoring
SQL Server TEMPDB - A key factor in monitoring and keeping up the performance!

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jan 13 2009
Filed under: Filed under: sql server, best practices, multiple, storage, tempdb, create, files, performance monitoring
SQL Server data and log files initialization, think multiple files, backup & restore performance!

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh. In addition to this when you talk about files intialization...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jul 25 2008
Filed under: Filed under: sql server, performance, restore, best practices, multiple, filegroup, backups, disks, throughput, files, tapes
SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?

When you think about high availability in SQL Server then you would think about Clustering and in addition to this within 2005 version we have Database Mirroring too that can provide automated failover support to your database server applications. By...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, May 8 2008
Filed under: Filed under: sql server, performance, high availability, best practices, cluster, support, database mirroring, instances, multiple, failover, scalability

Page 1 of 1 (5 items)

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.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

Guidance on installation to a multi-server PowerPivot for SharePoint farm.

SQL Server TEMPDB - A key factor in monitoring and keeping up the performance! (update)

SQL Server TEMPDB - A key factor in monitoring and keeping up the performance!

SQL Server data and log files initialization, think multiple files, backup & restore performance!

SQL Server - Deploying Database Mirroring and Clustering parallely on same machine, performance and failover support?