Browse by Tags

All Tags » performance » query   (RSS)
Quick tips & tricks on fine tuning performance problem on a SQL Server instance.
06 October 08 02:51 AM | SQL Master | 2 Comments   
Few months ago I had an excellent opportunity to learn and share the knowledge within SQL Server performance tuning, Tech-Ed Online talks [remember Tech-ed Online Panel: Leveraging ... ]. Same in the series Amit Bansal, SQL Server MVP from India and myself Read More...
SQL Server Performance - what it takes for a newbie DBA in resolving performance issues?
05 February 08 01:57 AM | SQL Master | 6 Comments   
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 Read More...
SQL Server 2005 methods to find table INDEX or Statistics age for better performance
09 January 08 01:55 AM | SQL Master | 4 Comments   
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 Read More...
High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!
20 September 07 08:40 AM | SQL Master | 2 Comments   
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, Read More...
Performance - check whether it is affecting application or system, don't blame SQL Server alone
03 September 07 07:42 AM | SQL Master | 2 Comments   
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 Read More...
Performance Tuning - will I loss the indexing when using derived table?
21 August 07 01:19 AM | SQL Master | 2 Comments   
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 can Read More...
Unused indexes on a database, its good and bad
27 July 07 06:51 AM | SQL Master | 3 Comments   
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 Read More...
Why is a SPID blocking itself in sysprocesses?
27 July 07 01:29 AM | SQL Master | 1 Comments   
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 that Read More...
Usage and good practices with UPDATE STATISTICS feature in SQL 2005
23 July 07 03:39 AM | SQL Master | 1 Comments   
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 Read More...
Why query execution timeout happens and find queries that have granted memory or waiting on memory?
23 July 07 02:44 AM | SQL Master | 1 Comments   
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 Read More...
SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?
10 July 07 03:40 AM | SQL Master | 1 Comments   
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 Read More...
Make use of tools and utilities that are available in SQL Server - performance & tuning
08 July 07 05:19 AM | SQL Master | 1 Comments   
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 Read More...
What to do if your SQL Server system is slow
06 July 07 08:41 AM | SQL Master | 1 Comments   
If you get such questions asked you will think about offending queries, but there is still more to take care of it. Joe Chang and other members in SQL Server performance website has contributed more about to it, Topic19594 for more informaiton. Read More...
How to check performance difference between 2 identical SQL Servers?
05 July 07 08:06 AM | SQL Master | 1 Comments   
Say you have two identical SQL Servers with similar databases in two different branches. Only the database sizes differ by about 20% and server machine are also identical. You will get a complaint that the performance of one is very very low compare to Read More...
Get a blocking list for the objects & indexes using DMV
13 June 07 07:44 AM | SQL Master | 6 Comments   
Yet another help from DMV I would like to share here, say on a SQL Instance you are getting low-level I/O and blocking intermittently. For the I/O issues using SYSMON (PERFMON) is ideal to get more information during the busy times and low-usage times Read More...
More Posts Next page »

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication