August 17, 2011 at 10:09 am
Hi ,
I am facing some performance issues with my database server.
one of the SQL blog i found that the below are set to on .
I checked with my database these options are set to false ::
Is it compulsory to change all these settings ???
* ANSI_NULLS
* ANSI_PADDING
* ANSI_WARNINGS
* ARITHABORT
* CONCAT_NULL_YIELDS_NULL
* QUOTED_IDENTIFIERS
Regards,
Lavanya Sri
August 17, 2011 at 12:02 pm
Those are ANSI standard settings. I'd say it's a good practice to have them on, but I don't think you'll see performance and indexing changes from having them enabled.
What performance problem are you hitting?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 19, 2011 at 1:48 am
HI Granty ,
The DB utilization goes to 100 % and teh same time we are getting alerts from the site.
By running profiler i found some queries , these quries are using more CPU time , and the remaining queries are going to sos_scheduler_yield .
This query is running from one applcaition server , when we cancel that query from the application , teh DB utilization goes to very low .
There is some indexing issue is there on that query .
Regards,
Lavanay sri
August 19, 2011 at 3:47 am
Also check the stored procedure is written efficiently...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 19, 2011 at 4:43 am
Then, post the query and execution plan too. We will help you.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 19, 2011 at 4:58 am
I would focus on the query, the code, not the ANSI settings. That is, unless you have an identical query with a different set of ANSI settings and you're getting different performance. Then, it's likely to be ANSI.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply