i have run this sql (copied it from the link you added) on the Server :

SELECT SUM(single_pages_kb + multi_pages_kb)/1024.0, type, name

FROM sys.dm_os_memory_clerks

GROUP BY type, name

ORDER BY SUM(single_pages_kb +...

Thanks for all the advice.

I will talk to our systemadministrator to see if i can get some new hardware...luckely he always likes ordering new servers 🙂

No, i know. a seperate partition only has some administrative advantages but nothing else.

But if i split the raid with 3 physical drives to 1 raid with 2 physical drives...

I've been talking with our SystemAdministrator and it appears that he set the hardware up as followed :

1 RAID Controller with 5 physical harddrives

The 5 drives are divided (using the...

Well...actually we have both.

There's a single index on the customerNo column, a single index on the OrderNo column and an index on both columns together

Hi,

I modified our backup so we use only 1 Bak file for all user databases.

The problem with the online backup utility is that once i uploaded a certain file, it...