I would keep it simple and reconfigure tempdb to 12 * 10240MB and re-assess.

You would be better off having more small files than 3 large files to reduced contention.

I don't recall any of those having changed but you'll have to review the appropriateness of each setting for your new setup.

I've seen quite a few old SQL...

sqlcentral2 (2/7/2014)

---

a) I thanked you politely for the reference.

b) I have not indexed the internet in my head and neither have you.

c) "it proves" that I didn't "google" well enough

c)...

sqlcentral2 (2/6/2014)

---

Thanks for that info - that's news. I will investigate that possibility.

The poster comment about number of partitions can stand forever, it will still be wrong. I have simply...

sqlcentral2 (2/5/2014)

---

Oh dear.

Msg 7719, Level 16, State 1, Line 1

CREATE/ALTER partition function failed as only a maximum of 1000 partitions can be created.

I can see now that the SQL2012 docs...

Was there any backup process occurring at the time?

Are you using this box as its own distributor? If so, this means the logreader agent is running locally and could potentially consume the CPU if there has been...

Jako de Wet (2/4/2014)

---

We have a recovery plan in place, I will run a comparison when the Backup is set to Bulk Logged and see what difference it makes.

We also...

Jako de Wet (2/4/2014)

---

I was thinking of taking the following approach to increase the speed, but would like some input before I start. I want to create a Script/Job that...

Litespeed doesn't restore native backups. All it does is use the same native restore TSQL you run through SSMS.

Attempting to restore a native backup using the Litespeed xp's will...

CREATE PROCEDURE [IncCondense] ( @latin INT )

AS

BEGIN

DECLARE @max-2 INT

, @min-2 INT

, @col3 INT

...

Objects are create on FILEGROUPS. This allows for them to be proportionally filled over multiple files depending on files sizes. This allows you to spread data reads/writes over...

Is this a native compressed backup? Backups have no bearing on the size of a snapshot. They...

Could you post the DDL and DML for what you want to achieve?

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

Is the job AND the schedule enabled? Either one can be disabled.