SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 SQL server performance
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sm112246
Starting Member

USA
1 Posts

Posted - 08/20/2014 :  21:14:14  Show Profile  Reply with Quote
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 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

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 08/21/2014 :  12:33:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
For the 2008 R2 database, is the query being blocked during those 10 seconds. Compare the execution plan for both queries. Is there a difference?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000