Browse by Tags

All Tags » sql server » performance » management (RSS)
SQL Server BI - Managing Large Datawarehouse environment, guidelines
Published 17 September 8 3:24 AM | SqlServer-QA.net
What will be the main challenge for a DBA/User to manage a large Data Warehouse (DW) environment, size does matter and also think about downtime you need to deploy whenever any patches are required. Before that you need to be perfect or well-versed with...
Filed under: , , , , , , ,
How SQL Server manages when a database is created in terms of I/O and disk usage?
Published 29 January 8 5:46 AM | SSQA.net
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...
Filed under: , , , , , , , , , , , ,
SQL Server: How do I identify the queries that are worth tuning?
Published 16 November 7 7:2 AM | SSQA.net
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...
Filed under: , , , , , , , , ,
Guidelines for enabling indexes and online index operations
Published 8 October 7 8:50 AM | SSQA.net
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...
Filed under: , , , , , , ,
Life of Simon, SQL Server DBA - hilarious video
Published 17 August 7 2:43 AM | SSQA.net
Also see Idera's hilarious new video! "Life of Simon, SQL Server DBA" http://www.youtube.com/ideradotcom View Video Format: ??? Duration: --:--...( read more ) Read More...
Filed under: , , , , , ,
Whats with 64 bit computing on SQL Server
Published 4 August 7 9:41 AM | SSQA.net
What advantages we took when deployed the 64-bit computing within SQL Server As you aware 64 bit computing with 64-bit processors have become the standard for systems ranging from the most scalable servers to desktop PCs. The way to take full advantage...
Filed under: , , , , , , , , ,
Dedicated Administrator Console (DAC) - saved an important day for a DBA
Published 4 August 7 9:9 AM | SSQA.net
Until recently I have just used Dedicated Administrator Console (DAC) to connect just to test whether the connection will be successful. You may be aware that only administrator will be able to access a running instance of SQL Server Database Engine to...
Filed under: , , , , , , , ,
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes ....)
Published 26 July 7 7:49 AM | SSQA.net
Error: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider...
Filed under: , , , , , , , , , ,
/3GB /PAE and AWE blurb what is it you hear within your environment?
Published 25 July 7 9:6 AM | SSQA.net
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...
Filed under: , , , , , , , , , ,
SQL Server consolidation & keeping up performance at the same time
Published 15 June 7 4:3 AM | SSQA.net
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...
Filed under: , , , , , ,
Have you looked at SQL Server Managment Pack?
Published 5 June 7 10:29 AM | SSQA.net
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...
Filed under: , , ,
How to find list of DMVs & DMFs?
Published 31 May 7 9:22 AM | SSQA.net
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...
Filed under: , , , , , ,
FILL Factor blurb to decide
Published 8 May 7 5:29 AM | SqlServer-QA.net (SSQA)
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...
Filed under: , , , ,
How to find that a query could benefit from an index?
Published 30 April 7 5:48 AM | SqlServer-QA.net (SSQA)
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...
Filed under: , , , , ,