Image in SQL 2005

[theresatan]

Hi,

Does anyone know SQL 2005 have any improvement the performance (read/write) of image/text stored in table?

As my experience, saving the image/text in folder and using a pointer in sql table has the best performance in SQL 2000.

My situation is:
Cluster server, 4 processors, 6 G memory, instance have one database only.

We have a lot of data including image/text imported to SQL daily.
The import tool is a C# App. It inserts data to SQL row by row (open connection, inserting data, close connection through a loop)

In SQL 2000, we saved image/text in folder without any problem
Since upgrading to SQL 2005, we save the image/text in SQL table.

I got following in SQL ERRORLOG many times per day:

A significant part of sql server process memory has been paged out. This may result in performance degradation. Duration: 302 seconds.
************************************************** **********************
*
* BEGIN STACK DUMP:
* 12/04/07 06:22:47 spid 0
*
* Non-yielding Resource Monitor
*
* ************************************************** **********************
* -------------------------------------------------------------------------------
* Short Stack Dump

I also get SQL server alert many times per day:
SQL Server Alert System: '020 - Fatal Error in current Process' occurred on XXX server

I told developer that they need to address this issue, but no one buys it because there is no problem in SQL 2000, neither is 2005. They ignore the changes they made.

I need your input:
It is storage issue (text/image in SQL table) or
It is loop issue or
Both or
Something else

Thanks in advance!

Theresa

[rmiao]

There are new data type varchar(max) and varbinary(max).

[theresatan]

Thanks for your input.

Yes, it provided more convinient to use it.
Does anything related to improvement of performance?

Theresa

[rmiao]

You need benchmark them since many factors can affect performance.