Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DanAgnew
Starting Member
2 Posts |
 Posted - 2009-09-17 : 14:26:16
|
| I have two SQL 2000 production servers that are not performing as well as I think the should. The big bottleneck seems to be involving large selects that have several ntext fields. The resulting bookmark lookups are taking 80% of the processing time according to Query Analyzer. I know that if I switch to SQL 2008, I can switch to nvarchar(MAX) and include unindexed columns in the index which should improve performance, but my question is by how much?I know that you don't have my data to see but in a nutshell I'm joining about five tables deep and my primary product table has about five ntext fields of 4000 characters (average) and around 100000 records.I'm also interested in performance differences in two-way replication between a pair of 2000 Servers vs a pair of 2008 Servers.Thanks in advance for any info you can give me.Dan Agnew |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-09-17 : 15:41:53
|
| Changing the ntext to varchar(max) will be a good help as data that can fit on the data page and data that wont will be on file storage. I dont think you can use nvarchar(MAX) in the INCLUDE column. Even if you could, that would be a bad candidate for the INCLUDE feature.If you can post your query/schema and your indexes someone can help narrow the issue down.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
SQL 2000 vs 2008 Performance