August 20, 2014 at 7:36 pm
Hello,
I am running into some sqlserver performance issues.
I have a table in (sqlserver 2008 R2) one of the database, with
less than 10 fields. One of the column data type is image and this table has about 300 records. we are storing word documents in this field.
I have a front end application connecting to this database and when I retrieve the results from the end application connecting to this table, it is taking almost 10 seconds. But once I update the image field to a blank for these 300 records , the form is coming up in 1 second in the front end.
However the same application is behaving fine in SQL server 2008 environment connecting to the same database.
The difference is have seen is one is SQL server 2008 and other is SQL server 2008 R2.
Also, when I compared the server properties for 2008 and 2008 R2,
i have observed that enabled processors ( server settings-- Advanced) is not checked for 2008 R2
where as enabled processors are checked for 2008.
I am not sure if this is causing any performance issue.
please help
thanks
subramanyam
August 21, 2014 at 3:22 am
I would suggest looking at the wait statistics by querying sys.dm_os_wait_stats before and after you run your query in order to understand why things are running slowly. I'd also look at the execution plan, especially if you can compare the 2008 version to the R2 version. That will help determine the choices made by the query optimizer based on statistics, indexes, and constraints on the table in question.
"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 21, 2014 at 4:25 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply