Thanks, can you explain a little bit more about :

9 of 12 is ok for a start, but may need to be lower if you see paging.

Thanks

So in my case as described above, should I stick with what our standard is (not sure why it is this standard) or should I use what is the default...

That's what I'm concerned.

We are in USA, and in our windows system, in region and language, the format is set up like English(United states.), -which is correct.

Does that mean if...

Thanks,

But I did search about those msdn articles about collation.

Our existing standard setting up by someone already left is Latin1_General_CI_AS.

But whenever now I install a new instance it is...

No, what I did just now is to setup the max memory for sql server to 9 gb, leave 3 gb to OS, will that help?

I didn't set up for...

I have the same issue. Any one has solutions about this?

Thanks

So when you say server side trace, is that a trace I can setup in SQL profiler and generated the sql script definition and run it as a sql agent...

I found out the link bitbucket-25253 provided is a very helpful article.

I changed it a little bit using mister.magoo's SP_NSForeachDB to query all the databases.

Thanks

For Welsh Corgi, I can use sp_who2 to check currently if the database in use, but not if the database in use in the past month or during the past...

mister.magoo provided the script does help a lot in some degree.

For the server I'm talking about we haven't restarted for a while.

and the script does provide some good information.

For the...

bitbucket provided the two links are helpful.

The first one is broken link, the second one I tried, it turns out it all accessed today.

So I think I may check more...

Thanks, this is a sharepoint database called something like ProjectServerTest_Draft. it also have database like ProjectServer_Draft, and a list all the databases for sharepoints.

And the server has not enough disk...

Thanks all, will look into the articles.

But just want to clarify this, so simple recovery mode's database, they will still use transaction log, but we still need to divide the...

Why do you think this is high CPU? Can you find it in %?

This report is called Top queries in total CPU time in SQL standard report.

For SQLDiag, is...

I pull a report from SQl standard report just now around 1:00 pm, the report is high CPU top queries, and found the database called Discovery which is the...