I've added this to our defrag process last night and the log file didn't grow much at all.

Thank you.

I...

Thank you sir,

I found that as well.

Looks like I'll have to wait for our latest test server which will be 64-bit.

Here is what I pulled from profiler:

Could not bulk load. The sorted column 'Version' is not valid. The ORDER hint is ignored.

The data type for 'version' is timestamp (not null).

I...

Good idea.

I've tried to recreate this snapshot a few times.

I'll try using profiler next.

James

I ran profiler for just the audit backup/restore events. From 10:45 -...

GilaMonster (1/28/2010)

---

I missed that the index was...

GilaMonster (1/28/2010)

---

Apollo74x (1/28/2010)

---

One of the fields showed a huge amount of user seeks on a column that already has an index on it. The only difference, is the missing...

Suresh B. (12/17/2009)

---

Why is a complete snapshot being generated when a new article is added (SQL 2005)?

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

This is expected behaviour if you have a merge or snapshot publication. If...

colin Leversuch-Roberts-108755 (9/25/2006)

---

it's really very easy .. here's an example for sql2k adding a table to transactional replication:-

--

-- add table to publication

--

exec dbo.sp_addarticle 'mypublication' ,@article='mytable',@source_table='mytable',@destination_table='mytable',

@force_invalidate_snapshot=1

go

--

-- refresh the subscription

--

exec...

Just wanted to give you all an update since this forum was very instrumental in helping us choose the right direction.

We chose to not add any other LUNS and we...

Paul White (6/24/2009)

---

Carl Federl (6/24/2009)

---

I think if you look further, you will find Cores 3 and 7 are handling all of the network IO , hence the higher CPU usage....

Paul White (6/24/2009)

---

I know I just seem to be posting links here, but http://technet.microsoft.com/en-us/library/cc966413.aspx is a Microsoft white paper on SQL Server 2005 Performance Tuning using the Waits and Queues...

The CPU...

Paul (6/22/2009)

---

I guess it is possible for one CPU to become saturated by processing I/O requests (particularly if all I/O is masked into one CPU) but that would be highly...