ah ha ! Thanks very much Gail - I am now able to at least draw a graphical plan on paper of what was happening - got it thanks a...

Thanks Gail. If i break it down can you advise if mu summary is correct ? I need to know if I reading the sections that refer to each other...

Thanks for the reply

I have fixed the issue. Unknown to me our hosting company, in service packing the server, had ended up doing a complete reinstall and so they had...

thanks a lot Gail - I will make the changes - hopefully it will help

🙂

yes I am seeing the following during our 'slowdown' period :

(20ms)PAGELATCH_UP:tempdb:1(PFS) when I run sp_whoisactive

Also when I query the servers top waits, PAGELATCH_UP accounts for the top wait at 22%...

So I should be ok adding 3 more tempdb files of equal size to reduce the tempdb contention issue ?

@Gail - Ive added the execution plan just now.

the table is defined as such :

USE [databaseX]

GO

/****** Object: Table [dbo].[WORKPATN] Script Date: 14/11/2014 15:37:40 ******/

SET ANSI_NULLS ON

GO

SET...

Not sure if i have done correctly - attempting to attach the execution plan !!:-)

A

So how would I know if its just 1 big transaction that grows the log during the process or a combination of things - in which case the checkpoint will...

thank you very much for your help -much appreciated

🙂

Thanks for the reply. What you describe is exactly what I thought. Would the following link help - It creates the logins from one server and you then run the...

Yeah I was going to change that 'grow by 10%' setting to something like 'by 250Mb' and size the log at a more reasonable size. I haven't set these...

check out ola hallengrens index maintenance solution. https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

You can target only indexes that are a certain level of fragmentation - this is better than using the standard maintenance plans...

I'm not aware of any way of querying that info from the meta data.

Why is the date important ? Are you running any kind of maintenance solution on your indexes...

Sometimes I'll see these errors only once in day, other days it can be quite a lot more - maybe 5 - 10 times.

We are using a hosted environment and...