I guess I am going to go with option 1.

between I am running SQL 2012 on Windows server 2019 without any issue.

It is 960GBx2 in software RAID1 with just 1 partition.

I don't have performance or uptime problem with current server, I saw those 3 servers with good offers and they have...

Mr. Brian Gale, thank you for this info.

This server specification can not be changed.

Also the disk space is already halved due to RAID 1.

On old server I have the same...

• This reply was modified 3 years ago by  bissagars.
• This reply was modified 3 years ago by  bissagars.

The table is being truncated because of the tool, it resets automatically at 12:00AM, I don't have control over it.

There is nothing we can do with current procedure?

First table you see 5x counts for "Name" he has 5 points. This data is saved dynamically from a tool.

Then it is saved for the Log table

I just tried the new SSMS V17, and I can't duplicate the issue with the new SSMS.
So maybe a bug with the old SSMS supplied with the SP4 update,...

so it is better to create 2x RAID 1 Array and separate the data/logs and make the daily backup on the physical array which is doing write activity only?

I don't...

Thanks for replies,

Unfortunately I don't know the throughput, I used a query to show how much read and write the db is doing and this is so far what I...