Hi,

I just want to make sure that Can I increase the page file size 1.5 times physical RAM?

I got the below readings from perfmon counters:

Paging File(\??\C:\pagefile.sys)\% Usage ...

Thanks Manu,

Under HKEY_LOCAL_MACHINE\SOFTWARE\ASP.NET I can see 2.0.50227.0 but I did nit find HKEY_LOCAL_MACHINE\SOFTWARE\Microsoftet framework setupdp

thank you,

So other than jobs created by maintenance plans, we can script out and and ran in sql server 2005 right?

We are doing side-by-side upgrade. In sql server 2005 also when we create maintenance plan,the related job will be created under jobs section right? So if we ran the job...

thanks,

when we create maintenance plans, the related jobs were created in sql server 2000 under jobs. If we script these jobs and run in sql server 2005, the jobs will...

I used windows authentication. Installing 2 named instances and applying SP2 both at one time is working fine. After a month,If I want to install 3 rd instance, the same...

is this any issue related to not applying any cumulative udates.Because We have only SP2 installed

Hi Cain,

Thanks for suggestion....But last couple of weeks ago we got similar kind of error which is directly telling that you need to contact microsoft as below..

2008-12-09 17:54:07.97 spid204 ...

Hi Jefferey,

I just wanna share my problems that I have encountered...sothat everybody will know the problem I faced and the solution I got from the forum experts

and Iam not just...

thanks Gail..I will go head and increase the datafile size..

thanks Gail,

Results after running DBCC Updateusage and sp_spaceused

sp_spaceused:in database 'system'

dbname database size unallocated space

system ...

thank you

Previously, I ran the sp_spaceused in the database 'system'. After running sp_spaced for the table processcontrol I got below results

Use system

GO

EXEC sp_spaceused N'dbo.ProcessControl'

GO

name ...

Thank you

The databases, tables, stored procedures,jobs and everything were created when BIZTaLK application was installed and configured.

It executing below procedure

USE [BizTalkMsgBoxDb]

GO

/****** Object: StoredProcedure [dbo].[bts_ManageMessageRefCountLog] Script Date: 12/21/2008 11:26:46 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[bts_ManageMessageRefCountLog]

AS

set transaction isolation level read committed

set nocount on

set...

thanks Gail,

We have 3 node a\a\p cluster setup.On node1 we have 1 instance and on node3 4 instances.

Presently we have memory issues on node1.Node3 is fine so far.

We have windows...