jump to navigation

Find out whats running on SQL Server 2005 December 13, 2007

Posted by furrukhbaig in DMV's, Execution Plan, Optimize, Performance, Performance Tuning, Profiler, Queries running on the server, SQL Server 2005, SQL Server 2005 features, XML Execution Plan.
Tags: , , , ,
trackback

Everyone wants to know whats running on the box. Specially if your job is to stabalise server you always concern what is killing the box.

A Friend of mine has published very usefull post with scripts to find out whats running on the SQL Server with their execution plan.

http://www.proteanit.com/b/2007/01/22/a-useful-script-to-analyse-current-activity-on-your-box/

The same can also be managed if you run profiler and capture XML execution plan which is not always possible due to security issue and overhead of profiler itself.

Advertisements

Comments»

1. Bhupendra Sainath Mudaliar - January 9, 2008

Hi All,

Can somebody explain in detail about Performance Tuning, I mean to say why we go for Perfromance Tuning how to answer i any body ask in interview,
Regards,
Bhupendra

Like

2. furrukhbaig - January 9, 2008

Hi Bhupendra,
Performance tuning is nothing more then understanding the behaviour of database engine and query optimizer. You can only write efficient code if you understand how this will be parsed and what steps will be involved in execution.

From the interview point, performance tuning playing vital and very important role as we deal with more and more data. now companies storing more data ever before more companies creating data warehouses and thats when ordinary practices does not work and you need to go an extra mile to understand the underlying engine and write your code accordingly. Performance consideration starts from DB design and to write a SELECT query. In a nutshell its to have a know how of db engine and optimizer to make him do your work the way want you want.
Thanks,
Furrukh baig

Like


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: