SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

Improve Performance on query execution - control Parameter Sniffing

published 783 days, 15 hours, 7 minutes ago posted by

sa 792 days, 16 hours, 47 minutes ago

Improve Performance on query execution - control Parameter Sniffing

Going back to basics 'parameter sniffing' is a process where SQL Optimizer helps (sniffs) the execution process any current parameter values during compilation or reccompilation process. It will attain a pass-along values to the query optimizer so that the values can be used to generate a potential faster query execution plan/policy. That helps in some cases but at not all of the execution fashion, such as huge volume of rows are returned. It is nothing but SQL optimizer replaces the constants 'literal'...(read more)

category: News | clicked: 1 | | source: sqlserver-qa.net | show counter code

tags: kba, Maintenance, monitor, parallel execution, Performance, profiler, Query, SQL Server

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

Improve Performance on query execution - control Parameter Sniffing

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up