Browse by Tags

All Tags » management » sql server   (RSS)
SQL Server: How do I identify the queries that are worth tuning?
16 November 07 06:02 AM | SQL Master | 2 Comments   
Have you ever asked this question about how do I identify the queries that worth tuning? The simple answer it is neither easy or hard to obtain such information if you have managed your SQL Server by deploying industry best practices (wherever possible). Read More...
Guidelines for enabling indexes and online index operations
08 October 07 06:50 AM | SQL Master | 4 Comments   
As a DBA you should now how locking works with tables and how best you can make use of indexing enhancements within SQL Server 2005 version. Until SQL 2000 there was a limited availability of documentation on the guidelines even in the Books online and Read More...
Disable SA account on a live SQL Server2005 instance, any drawbacks?
13 August 07 02:03 AM | SQL Master | 2 Comments   
Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more Read More...
/3GB /PAE and AWE blurb what is it you hear within your environment?
25 July 07 07:06 AM | SQL Master | 4 Comments   
You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From Read More...
SQL Server consolidation & keeping up performance at the same time
15 June 07 02:03 AM | SQL Master | 1 Comments   
So what are your options in Server consolidation and not to harm the performance for the applications that are happily sitting across your data center and you have this mammoth task to consolidate the servers to save physical space etc. No doubt that Read More...
Have you looked at SQL Server Managment Pack?
05 June 07 08:29 AM | SQL Master | 1 Comments   
SQL Server Management Pack, this is a good snippet to monitor the availablity and performance of SQL Server 2000 and 2005. This tool has also got ability to issue alerts for configuration problems. The Management Pack discovers Database Engines, Database Read More...
How to find list of DMVs & DMFs?
31 May 07 07:22 AM | SQL Master | 1 Comments   
As most of blogs in this section travels through usage of Dynamic Management Views (DMV) & Dynamic Management Functions (DMF) I have had an email asking What is DMV & DMF and how to find list of them from a SQL Server instance. The internal mechanism Read More...
What events will cause a flushing of plan in cache?
14 May 07 05:17 AM | SQL Master | 3 Comments   
We already know that using DBCC FREEPROCCACHE will have the affect of flushing all the cache with immediate affect and also DBCC FREESYSTEMCACHE (new in SQL 2005) has similar affect but will flush the plans asynchronously that are marked as unused anymore. Read More...
FILL Factor blurb to decide
08 May 07 03:29 AM | SQL Master | 0 Comments   
As all of us know that while creating Index for a Table there is Option for specifying Fill factor. This option specifies how full SQL should make in the Index Page while creating Index. Why this option is provided, should it not by default 100 ? What Read More...
How to find that a query could benefit from an index?
30 April 07 03:48 AM | SQL Master | 0 Comments   
Performance is most required achievement in a multi-user environment, using SQL Server 2005 this can be achieved with a few statments execution. Firstly you need determine the issues by finding which query or queries are causing issues in achieving performance. Read More...
Recompile all the stored procedures
27 April 07 06:42 AM | SQL Master | 0 Comments   
There has been many instances of requests from the Developers to recompile a set of Stored Procedures on one of the mission critical databases, due to the performance issues the relevant SPs have been fine tuned for optimum performance. In order to take Read More...
Execution plans caching and how SQL optimizer reuses for better performance
25 April 07 01:16 PM | SQL Master | 1 Comments   
Memory plays important role in Performance on a windows based platform, SQL Server 2005 features has a pool of memory that is used to store both execution plans and data buffers, only the part of memory is used to store execution plans that we call as Read More...
Estimated rowcount affects the performance - SQL 2005
25 April 07 01:02 PM | SQL Master | 1 Comments   
Using Query Analyzer you can get an estimated execution plan for a query against a database, in that plan the estimated number of rows is incredibly important when Query Analyzer is choosing an execution plan. In the real terms this is something to be Read More...
Database Tuning Advisor - how far it can help?
25 April 07 12:06 PM | SQL Master | 0 Comments   
SQL Server 2000 includes Index Tuning Wizard (launch from Enterprise Manager | Tools | Wizards... | Management) that allows selecting and creating an optimal set of indexes and statistics for a SQL Server 2000 database. This wizard is now being replaced Read More...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication