Browse by Tags

All Tags » performance » ssms   (RSS)
Whats the best way to setup memory on a four-node cluster?
06 September 07 02:42 AM | SQL Master | 3 Comments   
Though it is more to do with SQL Storage kind of question, I have just dragged into Performance tuning section for the sake of large installation you talk with clustering. For the sake of discussion it seems better to plan ahead for the failing instances Read More...
sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
17 August 07 06:04 AM | SQL Master | 3 Comments   
The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any 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...
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...
Things to take care for performance tuning after upgrading from SQL 2000 to 2005?
24 April 07 12:37 PM | SQL Master | 0 Comments   
The first thing that needs to be touched on is whether the upgrade is going to be performed by taking an existing SQL Server installation and upgrading it or by installing SQL Server 2005 on a new machine and migrating databases to it. Also use the Upgrade Read More...
RAID - performance key factor
23 April 07 10:21 AM | SQL Master | 2 Comments   
Both hardware RAID 1 (mirroring or duplexing) or RAID 5 (striping with parity) offer good data redundancy should a single hard disk in a RAID array fail. And as you might expect, there is some differences in performance between the two. The major difference Read More...

Search

Go

This Blog

«December 2008»
SMTWTFS
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Syndication