I would suggest you to go through the below mentioned article. This is is the one of the best article to troubleshoot the replication performance issues.

http://blogs.msdn.com/b/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx

Thank you very- very much. It helped.

Some more info if it helps:-

SQL Server 2008 R2 SP2 standard edition.

Database is Synchronous mirroring on the cloud.

Does this sql shows your db has been backed up?

SELECT a.Name AS DatabaseName,

COALESCE(CONVERT(VARCHAR(12), MAX(b.backup_finish_date), 101),'-') AS LastBackUpTime

FROM sys.sysdatabases a

LEFT OUTER JOIN msdb.dbo.backupset b ON b.database_name = a.name

where a.Name...

My mistake.

Get database id from from sys.sysdatabases and pass that as first parameter.

Try this.

SELECT

B.name AS TableName

, C.name AS IndexName

, C.fill_factor AS IndexFillFactor

, D.rows AS RowsCount

, A.avg_fragmentation_in_percent

, A.page_count

FROM sys.dm_db_index_physical_stats(null,NULL,NULL,NULL,NULL) A

INNER JOIN sys.objects B

ON A.object_id = B.object_id

INNER JOIN sys.indexes C

ON B.object_id = C.object_id AND...

Read through this below article and decide for your self.

http://www.sqlskills.com/blogs/kimberly/plan-cache-and-optimizing-for-adhoc-workloads/

http://technet.microsoft.com/en-us/library/cc645587.aspx

I think you are seeing the resource ballooning issue.

See if this could help.

http://mssqlwiki.com/2013/03/31/sql-server-and-vmware-ballooning/

Nevyn,

First of all thank you very much for looking into it.

You got all business rules right.

You have rightly answered all the questions but let me answer them again..

What...

Luis,

Here is the new set of data just on one location & sheet with expected results, if that helps.

Insert into [W_O_Schedule] Values

--Nothing from here since No Location Schedule

--SO Nothing

(1,1,'Available','Weekly','2013-06-03...

Sorry about that. Let me try to explain it more.

Location may be wide open, but resource schedule may be limited or vice- versa. In that case I have to...

Thank you very much Luis for looking into this.

This is very helpful. Sorry about 30 hours in a day.

I was just testing it and it looks very promising, but is...

Just putting the code inline.

Create Table Schedule (

Studio int,

PromotionID int,

CameraRoomID int ,

StartTime DateTime,

EndTime DateTime,

ScheduleType int, -- 1 Weekly--2 OneTime

Available int) --1 Available--2- Closed

GO

--Delete from Schedule

Insert into Schedule

Values

(1, 1,...

Making it easier for others.

http://www.google.co.in/url?sa=t&rct=j&q=upgrade%20sql%20cluster%20to%202008%20r2%20doc&source=web&cd=4&cad=rja&ved=0CEIQFjAD&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F3%2F0%2FD%2F30DB8D46-8ACF-442A-99A2-0F4CE74AE14D%2FSQL_Server_2008_R2_Upgrade_Technical_Reference_Guide.docx&ei=VR-jUcLHCcT5rAex_IGwAw&usg=AFQjCNFbFN_E9gZKFZbyh6xaenuME_b7rw&bvm=bv.47008514,d.bmk

There is a way to run pull subscription with SQL Server express.

Here it is.

But there may be other reasons for the slowness. try to find out what else is causing...