Browse by Tags

All Tags » query » performance (RSS)
A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000
Published 12 May 8 1:43 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...
Filed under: , , , , , ,
Query Execution Plans security and new feature within SQL Server 2008 Management Studio
Published 4 March 8 2:4 AM | SSQA.net
If there is any performance issue within your queries then looking at query execution plan is the first step towards assessing the loss, you may be aware that execution plans of queries and queries on partitioned tables and indexes can be examined by...
Filed under: , , , , , , , , , , ,
SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
Published 5 February 8 2:57 AM | SSQA.net
SQL Server Performance Tuning, sounds familiar on a DBA perspective and though it sounds like an easy words but when you start analyzing the problem it is far deeper inside. When you refer to the web resources such as forums/newsgroups then a common question...
Filed under: , , , , , , , , , ,
SQL Server Analysis Services MDX Query performance monitoring - highlights
Published 29 January 8 3:27 AM | SSQA.net
When it comes to monitor the query performance whether it is TSQL or MDX, the process is similar. You need to have a better understanding on how queries are executed (architecture), what tools are available for monitoring and best practices to improve...
Filed under: , , , , , , , , ,
SQL Server 2005 methods to find table INDEX or Statistics age for better performance
Published 9 January 8 2:55 AM | SSQA.net
Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller...
Filed under: , , , , , , , ,
FIX: A query that has many outer joins takes a long time to compile in SQL Server 2005
Published 17 October 7 4:13 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications...
Filed under: , , , , , ,
High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
Published 20 September 7 10:40 AM | SSQA.net
Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...
Filed under: , , , , , , , , , , , ,
Another Best Practices article: Identifying and Resolving MDX Query Performance Bottlenecks
Published 5 September 7 4:34 AM | SSQA.net
Best Practices are good enough to follow, but simply do not read and digest. Try to implement them within your environment to keep up the performance. Similary there are many things involved within the SQL Server 2005 Analysis Services such as MDX queries...
Filed under: , , , , , , ,
TSQL to obtain a list of current execution of Parallel Plans (MAXDOP)
Published 4 September 7 9:32 AM | SSQA.net
PARALLELISM is a close friend of DBA where you get to see it as a common occurence in the multi-processor server environment and during such performance issues you can also investigate whether a parallel plan is in use. For instance If a particular query...
Filed under: , , , , , , , , ,
Triggers within CLR - advantage over TSQL
Published 4 September 7 4:10 AM | SSQA.net
You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested...
Filed under: , , , , , , , ,
Performance - check whether it is affecting application or system, don't blame SQL Server alone
Published 3 September 7 9:42 AM | SSQA.net
Its a general assumption that whenever performance is degraded, the finger will be pointed to SQL Server, pretty easy eh!? If you look at any of the SQL Server related forums then 3 in 10 questions asks same question and nothing but shove blame on SQL...
Filed under: , , , , , , , , , ,
FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005
Published 30 August 7 5:0 AM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...
Filed under: , , , , , ,
TSQL to detect long running queries against the database
Published 29 August 7 6:37 AM | SSQA.net
When I'm performing a performance analysis on a 24/7 application and dealing with PSS I had been given the following TSQL to identify the long running queries against a database. select r.session_id, s.host_name, s.program_name, s.host_process_id...
Filed under: , , , , , ,
Performance Tuning - will I loss the indexing when using derived table?
Published 21 August 7 3:19 AM | SSQA.net
This was the question asked by a Developer when we are investigating a performance loss issues on a database. To the point a derived table means a virtual table that's calculated on the fly from a select statement. By default using derived tables...
Filed under: , , , , , ,
Unused indexes on a database, its good and bad
Published 27 July 7 8:51 AM | SSQA.net
You may be aware that the indexes on a SQL Server database take up space, so in case of unused indexes its obvious that they waste storage. It is easy to find the indexes using SP_HELPINDEX statement against a table, so to identify the unused indexes...
Filed under: , , , , ,
Why is a SPID blocking itself in sysprocesses?
Published 27 July 7 3:29 AM | SSQA.net
This was the question asked during an interview that was attended by one of my friend, I'm not sure how he managed to answer but came to me asking how it is possible. For your information af ter you apply SQL 2000 Service Pack 4, you might observe...
Filed under: , , , ,
Usage and good practices with UPDATE STATISTICS feature in SQL 2005
Published 23 July 7 5:39 AM | SSQA.net
UPDATE STATISTICS is very helpful to get the performance by updating the distribution of key values for one or more statistics groups or set of collections in the specified table or indexed view. So how this is handled within the SQL Server, you may be...
Filed under: , , , , , , ,
Why query execution timeout happens and find queries that have granted memory or waiting on memory?
Published 23 July 7 4:44 AM | SSQA.net
Have you ever identified the reasons for why and how does a query execution timeout happens within your SQL Server environment. For the beginners I would like to explain that b efore executing a query, SQL Server estimates how much memory it needs to...
Filed under: , , , , , , , ,
SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?
Published 10 July 7 5:40 AM | SSQA.net
If you have a huge volume of table (say millions of rows) and a requirement to limit x number or sample of rows from a query every time you execute. To limit number of rows then you would think about [ select ... from (select top 100 * from X order by...
Filed under: , , , , ,
Make use of tools and utilities that are available in SQL Server - performance & tuning
Published 8 July 7 7:19 AM | SSQA.net
There are various tools available within SQL Server installation such as SQLDIag, SQLDumper, PSSDiag (to be downloaded as a seperate tool), SYSMON(PERFMON) and Profiler etc. Among these SqlDiag and Sqldumper are most important to get more information...
Filed under: , , , , , , , ,
More Posts Next page »