155 reputation
9
bio website gfk.com
location United Kingdom
age 37
visits member for 1 year, 6 months
seen Mar 25 at 11:25

Web Operations and database administration


Mar
20
comment Running MongoDB and SQL Server on the same host- memory pressure
Max memory is default.
Mar
20
comment Running MongoDB and SQL Server on the same host- memory pressure
Edit: included additional facts and figures.
Mar
20
revised Running MongoDB and SQL Server on the same host- memory pressure
added 202 characters in body
Mar
20
asked Running MongoDB and SQL Server on the same host- memory pressure
Oct
31
asked Approaches for Real time copy of database on same SQL Server instance
Sep
23
awarded  Informed
Sep
23
comment Excessive replication snapshot size causing failure
Thanks Kin, Kendal Van Dyke's approach is interesting.
Sep
23
accepted Excessive replication snapshot size causing failure
Sep
23
comment Excessive replication snapshot size causing failure
I changed format to Native and found that the snapshot size reduced, although was still larger than the original database file - 162GB. Many thanks.
Sep
19
comment Excessive replication snapshot size causing failure
Running full snapshot again tonight, this time in Native mode
Sep
19
comment Excessive replication snapshot size causing failure
Thanks Kin, we're considering this as an alternative
Sep
19
awarded  Editor
Sep
19
comment Excessive replication snapshot size causing failure
Sorry, copy/paste error. The opposite seems true - Native larger than Character. Corrected file sizes in post.
Sep
19
revised Excessive replication snapshot size causing failure
corrected BCP file size figures
Sep
19
comment Excessive replication snapshot size causing failure
Native mode C:>bcp IVM_ArchiveTest.dbo.Event out D:\NOBACKUP\UseOnce\EventNat ive.dat -T -n 218977 rows copied. Network packet size (bytes): 4096 Clock Time (ms.) Total : 7878 Average : (27796.01 rows per sec.) file Size:66 MB Character mode C:\>bcp IVM_ArchiveTest.dbo.Event out D:\NOBACKUP\UseOnce\EventCha r.dat -T -c 218977 rows copied. Network packet size (bytes): 4096 Clock Time (ms.) Total : 1654 Average : (132392.38 rows per sec.) file Size:105 MB
Sep
19
comment Excessive replication snapshot size causing failure
Thanks! This confirms my suspicions, however, my tests don't seem to support this
Sep
19
asked Excessive replication snapshot size causing failure
Jul
30
awarded  Teacher
Jul
25
awarded  Popular Question
Jun
28
accepted Diagnosing Blocking issues using Blocked Process report