Luis Cazares (4/29/2015)

---

It depends on what you're inserting. Does all the information needs to be available at the same time? You could do inserts on batches to prevent long times...

Actually, we are using a staging server, that stays between our vendors and us, but in our hands.

But in...

The...

cunningham (4/29/2015)

---

What recovery model is the database in? if full set to bulk logged for the bulk insert operation. Are there any unused indexes on the table? get rid of...

OK, that's OS, now I am convinced. But here is another question: how to find OS processes that contribute the most to pages/sec?

Thank you both for replies.

But as I understand correctly, once SQL Server reached its max. server memory, it does not give it back to OS. For example in my situation...

MVDBA (4/17/2015)

---

microsoft documentation states that it is linear fill for log files ....

we can't do initialise from backup as there are multiple publications replicating to the subscriber database - restoring...

You just answered to your question - yes it is proportional fill.

But let me ask you another question: why don't you initialize replication with backup/restore? You won't have such...

Are you trying to copy from SSMS using xp_cmdshell or from Windows Explorer via RDP to the box?

Thanks Grant for these leads.

I am not experienced with extended events, so I started digging with sys.dm_exec_query_stats. Particularly with total_physical_reads. But what I can use to join two snapshots of...

select p.publication,

status = cast(m.status as smallint)

from MSpublications p join MSreplication_monitordata m

...

Database diagrammer in SSMS

use msdb

go

select s.backup_set_id,

s.first_lsn,

s.last_lsn,

s.database_name,

...

These are not initial but current sizes. SQL Server does not keep the file size at the time when you have initially created database. Check sys.database_files view. It has size,...

It will work. But is this production? In order to insure that no data will be lost while database in simple recovery model, try to get an outage window from...