Browse by Tags

All Tags » performance » microsoft   (RSS)
SQL Server performance monitoring requirement and specifications, heard about baseline and benchmarking?
19 December 07 05:06 AM | SQL Master | 3 Comments   
How do you define the terms "Performance Monitoring"? What is your baseline & benchmarks? Have you ever used PERFMON (SYSMON) & PROFILER for serious performance issues within your SQL Server environment? The answer may be not 'yes' for all the Read More...
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...
If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?
15 November 07 08:41 AM | SQL Master | 2 Comments   
Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must Read More...
NTFS Cluster size - if changing the default cluster size on the disk is a good idea or not?
16 October 07 05:18 AM | SQL Master | 2 Comments   
You might have come across on the web resources that setting the disk to a 64k cluster size (8 * 8KB pages) might achieve the performance. But have you wondered will this really boost the disk performance, see in what scenario such as lots of reads and Read More...
Determining the required capacity of an I/O subsystem before deploying the database
17 September 07 06:49 AM | SQL Master | 4 Comments   
It is a good practice to determine the required capacity for a database application before it is deployed on the Production environment. As it speaks the I/O system is "most" important to the performance of SQL Server, in the event of any performance Read More...
SQL Server 2005 using Cryptography & Encryption what they are for?
13 September 07 05:46 AM | SQL Master | 2 Comments   
Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication, Read More...
How to gain Disk related performance with few simple steps
30 July 07 07:24 AM | SQL Master | 4 Comments   
Within your SQL Server environment there are few simple steps you can take up in order to gain performance to a level, for instance when configuring a SQL Server that will only contain a few gigabytes (GB) of data and not sustain heavy read nor write 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 2005 Security best practices on the Administrative tasks
06 July 07 09:08 AM | SQL Master | 1 Comments   
You have various references available on the web about things to take care on the security management for SQL Server, in addition to the SQL Server 2005 Books Online . Features and options that are new or defaults that are changed for SQL Server 2005 Read More...
Performance and Scalability: SQL Server 2005 Enterprise Edition Benchmarks
20 June 07 01:42 PM | SQL Master | 1 Comments   
SQL Server 2005 achieved the #1 price/performance result for 3TB TPC-H non-clustered benchmark. This is a record breaking TPC-H three terabyte benchmark for a database running on Microsoft Windows and an HP Integrity rx8640 Server. The recent TPC-H benchmark 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...
Linked Servers performance - things to check
25 April 07 07:44 AM | SQL Master | 0 Comments   
I'm going to put the content that has been discussed in SSP forums about the Linked Server performance issues, there is much information available on the factors what you need to consider to avoid the performance loss. Here is the relevant forum post Read More...
Stress testing for application - tuning exercise
25 April 07 06:48 AM | SQL Master | 0 Comments   
Recently I have had a job to generate a test on a disk subsystem to test a capacity growth on one of our SQL Server system. I was referring through this LessonsLearned article by Geert Vanhoe to simulate the stress testing, I'm aware about using SQLIOSTRESS Read More...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication