I attach another copy of .txt file

The perf run from 6:00 am to 6:10 am. Then after that around 6:11, I got some blocking message, that says master database is...

I attach another copy of .csv file

The perf run from 6:00 am to 6:10 am. Then after that around 6:11, I got some blocking message, that says master database is...

Thank you , I will looking into the attachment and links.

I attached the perf counter I colllected this morning. See attachment, please let me know how you read them and...

I setup the job using T-SQL and output to a file. I tried, it runs fine.

But the problem for my case is I already found some sql jobs are...

I found more information about the block issue. I setup a job to run SP_who2 around the morning peak hours, but I found nothing collected for the sp_who2 at...

OK, I will set it up and post the result tomorrow.

And for the last statement:At last of the monitoring period, collect the output of DBCC MEMORYSTATUS

This cannot be included in...

So shall I change the dbowner to sa using sp_changeowner, then drop the login?

Thanks

Thanks, I said in my post she created two databases, so she is the owner of the databases, correct?

I just checked, if I right click the database -property, I can...

Thanks, but for monitoring Memory and CPU which are the dmv tables should I use?

Thanks

Thanks, can you be more specific when you say:

First create the same table as DMV and then insert data ...

Thanks

Thanks, that's what I experienced too. So I will use in the server then.

But for sql profiler trace, can you confirm it is easy to run on my local computer...

I found I can setup a sql profiler that run on my local computer to monitor a sql server, but for using windows performace monitor it seems it can only...

Thanks, but this instance is on standard version of 2008, so I don't see data collector.

This is one of them:

SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIO

138SUSPENDEDilsSN2.masterDBCC181317267

149SUSPENDEDsssgswe1138tempdbEXECUTE08042

So do I have to search by title, but I cannot remember it.

I search by usename, I still only get 15o.