I would suggest to contact SQLCAT (ms sqlserver customer advisory team) !

They may have more experience with that kind of volume(s) and may be in close contact with the sharepoint...

Did you try to handle it this way ?

ALTER PROCEDURE [EDMS].[sp_DeleteArea]

@PageID int,

...

peace2007 (3/14/2009)

---

here's the stored procedure that most of the times cause time out. on the previous messages u said that some clustered indexes should be defined on related tables. I'd...

Can you try to provide a valid password for the sqluser sa

IMO, even if sql auth is not actively in use for the instance, the upgrade will validate...

I did write a little article "adventures with service broker" stating my first experiences with SSB.

http://www.sqlservercentral.com/articles/Service+Broker/2897/

IMO Klaus Aschenbrenners book is still one of the best !

(Pro SQL Server 2005 Service...

chicagonj (3/12/2009)

---

Ok...looking under Management, Current Activity, Locks/Process ID

Out of the hundreds of entries, there are entries labeled as 'Blocked By XX' When i click on those, I'm getting 3...

This proc (in master db please) shows blocking activity

-- ALZDBA install sp_DBA_WhoBlocks.sql

-----------------------------------

USE [master]

GO

/****** Object: StoredProcedure [dbo].[sp_DBA_WhoBlocks] ******/

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_DBA_WhoBlocks]') AND...

Keep in mind you cannot drop objects that are actually in use !

I didn't test resend features for dbmail.

I don't think this feature is supported, unless you actually recompose the mail and issue another sp_send_dbmail

The view must be dropped first if it has been created using schemabinding

you stated cpu and memory were ok.

What's the ammount of physical RAM on the windows server, how much is in use and how much is in use by sqlserver ?

Any...

can you free the proccache ?

(to get rid of the "unperformant" plans)

dbcc freeproccache

Maybe now (holliday) is the moment to rebuild indexes, ...

befor you implement the new ones.

We've recently had a...

As SQL Noob stated, contact your mail admins, they will be able to find your mail (or in an output queue or in an received state, but maybe filtered by...

leonp (3/11/2009)

---

I wanted to check on a regular basis if all the databases we have online are being backed up and devised the following script -

select x.name as 'Databases...

My guess, your delete generated a bunch of log and is still running (cascading deletes ?)

DBCC opentran (executed in the correct db) may give some answers.