Thanks Matt.

When AWE is enabled on Windows 2003 + SQL Server EE 2000 SP4, SQL server does utilize the maximum memory allocated at start up.

Below is the explanation that I...

AWE is enabled

Hello,

I am trying to setup replication between SQL 2005 and DB2 with microsoft OLE DB provider for DB2. I am using the data access tool to setup the connection.

Provider=DB2OLEDB;User ID=XXXXX;Initial...

I am having the same issue too. I am trying to replicate data from SQL 2005 to DB2. Gettign an error MSSQL_REPL20084.

Any help would be appreciated.

Does any one have a resolution to this problem?

Thanks for the all the above suggestions. They have been done. But still SQL is not utilizing more than 28 MB of memory.

Min memory is set to 2 Gigs

Max...

yes both AWE and /PAE are enable.

Counters:

In SQL Performance Counter:

SQLServer:MemoryManager

Target Server Memory(KB) is not equal to tOTAL sERVER mEMORY(kb)

yes, the service account that sql server services run on does have lock memory pages rights...

Version of SQL is : 2005 EE + SP2 32 bit

Min memory is 2 Gigs, Max Mem is 14 Gigs.

Memory utilization of SQL Server in the perfomance counter is 28...

I called Microsoft and was on phone with them for 6 hours yesterday. They were not able to give me an explanantion. They turned around and said that, this is...

I am experiencing some issues with SQL Server 2005 installation.

Task Manager on the active node of the server shows Total Physical Memory :16776172 and Available Physical Memory :...

Thanks Jason,

Would you mind taking a look at another question that I have?

I have a Network Load Balanced Web Farm ( 2 Nodes configured as Active - Active) with SQL...

Hello Jason,

Your article holds good for subscription via email but not subsscriptions to a share. Hope there is a way to do it

Thanks

Prakash BhojeGowda

Hello,

I have a Network Load Balanced Web Farm ( 2 Nodes configured as Active - Active) with SQL Reporting services installed. Report Server database is on the SQL server. When...

Hi Steve,

I had the same problem as Andrew. I renamed the GUID with the report that was being generated. Later, I found out that there were two jobs running: one...