.. and, frankly speaking, i was pretty sure that truncating log with BACKUP LOG [db] WITH TRUNCATE_ONLY also marks log space as reusable...

Regards,

Slawek

Hi,

Actually I had this problem with two databases. Two out of seven on that server. One was in Full recovery model, and another was already in Simple, and on both...

That's what I was afraid of 🙁

Thanks.

Slawek

Thanks,

Funny thing:

ALTER DATABASE [dbname]

set recovery simple

DBCC SHRINKFILE (2,TRUNCATEONLY)

ALTER DATABASE [dbname]

set recovery full

worked fine... (I didn't wanted to use SHRINKDATABASE as I have pre-sized data files, which I didn't...

SQL2008 ? No direct replacement I'm afraid. Change recovery model to Simple and then back to Full.

FYI: List of discontinued database engine functionality in SQL 2008 is here:

.. and this:

was just a...

That's what I'm going to do.

I was just not sure how many files and how configured would be the optimal config, because I was not sure how SQL assigns threads...

Hi,

1. Regardless the database requires 70k IOPS or not leaving hardware operating at 10% or 25% of its limits is a simple waste of resources, especially I don't need to...

You are definitely software ortodox 🙂

I have hardware which is capable of doing 800 MBPS and 70k IOPS (at least that's what manufacturer claims, which I don't believe) why should...

Hi,

Well, if you convince me that fixing indexes will improve SAN performance, then I'll drop all my tests with multiple files and start fixing indexes 🙂

My problem is that single...

Thanks GilaMonster - that was exactly what I was looking for.

To sum up:

Single worker per separate IO path, up to maximum of number of CPU cores or I/O affinity....

Hi,

Actually you may try to use Message Queueing system. The task will be to send MSMQ message in one procedure, and receive it in another. I know that outside...