Thanks, will give it a try

GilaMonster (1/15/2013)

---

The Checkpoint begin has a time, so does the begin transaction log record. The transaction log is not an audit log, the log records don't all need to have...

Thanks, I use a query to check I/O usage like refered in this article:

http://sqlblogcasts.com/blogs/steveh/archive/2011/03/22/do-you-send-output-from-sys-dm-exec-query-stats-to-your-developers.aspx

My question is : does the query in the link include I/O usage for back up and...

For backups it usually happens on the same server.

For restores we usually do manually restore on local by copying the backup file to local.

Does reindex or update statistics also use...

I ask because our network people are investigating some SAN I/O issues.

They are wondering the backup or restore could generate a lot of I/O and cause problems.

They just...

SQLRNNR (1/14/2013)

---

I have seen vcenter do this on quite a few occassions. IIRC there was a patch for it.

I would also only do these during offhours with that database.

Please...

Thanks, it is using the update statistics task item in maintenance plan.

The View T-SQL, part of it is like:

UPDATE STATISTICS [dbo].[VPX_TEMPTABLE0]

WITH FULLSCAN

GO

use [vCenterDB2]

GO

UPDATE STATISTICS [dbo].[VPX_TEMPTABLE1] WITH FULLSCAN

GO

use [vCenterDB2]

GO

UPDATE STATISTICS...

As a sidebar, though, this is precisely what the DOS level "archive" bit is for. Any decent tape backup worth it's salt will turn the bit off at the...

I did, but I still did not get my question answered.

In the above article you give me:

it also says:

The two types of roles complement each other and should be used...

But I read from this site: http://msdn.microsoft.com/en-us/library/aa337385(v=sql.105).aspx

it says: Each user who requires access to a report server should have a system-level role assignment

also: b.Assign the System User role to all...

Thanks, I understand that.

But in most cases, even SQL server is up later than application server, the application still works.

I just want to know why this happens?

thanks

Thanks all.

Also the following is a related question.

Because we are going to do a data center maintenance for a lot of servers, we help networks group to shut down servers.

We...

Thanks, that is what I think too.

Thanks, that is helpful!

Thank you both for this, this makes much clearer to understand!