Check this out: https://support.microsoft.com/en-us/kb/811889

Might be something in here for you: http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html

I always do it like this:

DECLARE @command VARCHAR(1600)

SELECT @command = 'Use [' + '?' + ']

SELECT file_id,

name...

FROM sys.database_files'

EXEC sp_MSForEachDB @command

Warning. Incoming thrashing. Prepare for impact!

Throw this in there to help you troubleshoot:

SELECT SUSER_NAME(), USER_NAME();

Might be worth a look:

SQL Server Multi-Subnet Clustering

...and then setup a couple high availability replicas.

Love this quote:

Scale Up

- Servers are like pets

- You name them, and when they get sick, you nurse them back to health

Scale Out

- Servers are like cattle

- You number them,...

Are you building the new "Standalone SQL Server" and migrating to it?

How much data do you have to move and what is an acceptable amount of downtime?

You can some read/write info from sys.dm_exec_query_stats

There's also dm_io_virtual_file_stats (replaces the fn_virtualfilestats)

TX Replication can be a pain. It's not the best solution, but I know a lot of people move to Availability Groups so they can get readable secondaries without...

Jim_K (3/10/2016)

---

AFAIK JTDS doesn't support AlwaysOn/HADR in the sense that it won't handle failover as one would expect (it can still connect just fine). However, Microsoft's jdbc driver does and...

1200 read IOPS isn't much.

Here's what my new build looks like:

-----------------------------------------------------------------------

CrystalDiskMark 3.0.4 x64 (C) 2007-2015 hiyohiyo

...

Any additional information in that "RS Scripter Load Log.txt" file?

Could just be over provisioned RAM, and you're only seeing the lazy writer doing its thing.

What does Buffer Cache Hit Ratio and Page Life Expectancy look like?

There's some good stuff...

Not to be snarky, but google "sql server non default port"