Browse Blog Posts by Tags

All Tags » SQL Server » performance (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

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

Calling Stored procedure from EF takes long time and times out!

Hi Folks, I was going through an interesting performance issue when calling a stored procedure from my web application more than one time and the WCF was timing out because of the stored procedure execution takes long time to execute. At the first, I...

Posted to Moustafa Arafa Blog by on Wed, Mar 20 2013
Filed under: Filed under: asp.net, EF, Performance, SQL Server
Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook

When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that will activate the failover or failback whenever the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 9 2012
Filed under: Filed under: sql server, performance, high availability, database mirroring, key, solution accelerator, cookbook, #sql2k8r2cookbook
SQL Server performance series: PAGELATCH_ and PAGEIOLATCH_ wait types: relates to concurrency, take steps in diagnosing and resolving latch contention issues.

Contention is the word that you need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of w hen multiple threads concurrently attempt to acquire incompatible latches to the same...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 18 2011
Filed under: Filed under: sql server, perfmon, performance, memory, tuning, dba, cpu, performance monitoring, buffers, wait stats, dmvs, pageiolatch
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
Data Warehousing 2.0 and SQL Server: Architecture and Vision

As Data warehouses mature over time, the emphasis shifts from making data available to consumers to the production of data. Let’s look more closely at the data warehouse, beginning with an overview of its components. A data warehouse has a long life span...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jun 13 2011
Filed under: Filed under: sql server, performance, dba, etl, data warehouse, data center, parallel processing, pdw
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
Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 24 2011
Filed under: Filed under: sql server, performance, availability, mvp, dba, programming, best practice, monitoring, beginners, ebooks, architects, scalability, experience, book, packt, real-world
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 Manageability series: Server editions - choose the appropriate ones.

What is the default SQL Server edition used in your organization? As a DBA/Architect are you involved in deciding what version and edition of SQL Server to be used? As a DBA do you decide which version is suitable for the application needs? It is evident...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Mar 17 2011
Filed under: Filed under: sql server, performance, web, standard, installation, feature, setup, Partitioning, editions, enterprise edition, workgroup
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
SQL Server Performance series: Parallel query processing gotchas

Parallel query processing is one of the best performance features available from SQL Server 2008 version onwards. By default Microsoft documentation suggests to change MAXDOP settings remain equal to number of physical processors that are being used on...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Mar 7 2011
Filed under: Filed under: sql server, performance, memory, dba, processes, worker threads, numa, statiscs age, resource governor, maxdop
SQL Server Performance series: Parametrized Index optimization to handle each fragmentation group

As a DBA handling SQL Server platform performance issues is not an easy task in a multi-server and multi-database environment, in order to keep up the availability and scalability it is important to manage the database fragmentation on SQL Server in addition...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jan 9 2011
Filed under: Filed under: sql server, performance, dba, optimization, best practice, update statistics, index rebuild, reorg
SQL Server Memory gotchas within Windows 2003 and Windows 2008 enviornment, issues and problems

On a peaceful friday night had a pager for a severed problem in one of the SQL Server instances! When I looked at the error not a good one, preliminary message from alerting software was " Description: The SQLBrowser service was unable to process...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jan 5 2011
Filed under: Filed under: sql server, performance, memory, kba, error log, paged, 64 bit, worker threads, operating system, issues, working set, spawn threads
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 wait types - keep a close watch on IO_COMPLETION and WRITELOG :: sqlperf

In the recent times I have had few opportunities to work on a slow performance related issues, having the usual monitoring methods in place the server instance was suffering slow performance (at times). Though it is essential to keep an eye on database...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Oct 7 2010
Filed under: Filed under: sql server, performance, tuning, dmv, transaction log, dba, disk, writelog, wait type, writes, wait stats
Find slowest running queries on SQL Server instance

If the users are getting what they wanted in time, then no complaints on your day job as DBA. As a best practice you might have few alerts and responses in place to tackle bigger problems to solve, but in case of any performance problem that is not causing...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 13 2010
Filed under: Filed under: sql server, performance, dmv, dba, cache, tsql, slow, execution, query plan
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

Page 1 of 14 (268 items) 1 2 3 4 5 Next > ... Last »

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.