What counters should I monitor to get information what caused the slow response of applications that has their databases on the server?

Thanks

Thanks, if I setup a perf log on the sql server that has the slow response time, does the performance monitor itself affects the performance too?

Is there a way that...

Thank you.

I go to link above called My posts, it only returns 150 results.

Where can I find the other posts?

Thanks

Thanks, I setup a job using sp_who2 to catch.

See below, the lines may be now in align, but I cannot find a way to post corretlly

SPIDStatusLoginHostNameBlkByDBNameCommandCPUTimeDiskIO

11SUSPENDEDsa..masterCHECKPOINT11528136547

11SUSPENDEDsa..SharedServices2_DBCHECKPOINT11528136570

11SUSPENDEDsa..masterCHECKPOINT11532836600

11SUSPENDEDsa..masterCHECKPOINT11532836600

11SUSPENDEDsa..masterCHECKPOINT11551536665

2SUSPENDEDsa..(null)LOGWRITER166140

2SUSPENDEDsa..(null)LOGWRITER166171

2SUSPENDEDsa..(null)LOGWRITER166171

2SUSPENDEDsa..(null)LOGWRITER166171

2SUSPENDEDsa..(null)LOGWRITER168359

83SUSPENDED.WSS_Content_CollaborationSELECT76640468108

83SUSPENDED.WSS_Content_CollaborationSELECT78281479179

83SUSPENDED.WSS_Content_CollaborationSELECT96500575951

Thanks a lot, I will do a search in the site.

How can I monitor the backup file size increase?

Thanks, so I think I can setup a sql job that use transact_sql and run sp_helpfile. to output to a text file.

You said there are serveral ways, so beside sp_helpfile,...

Thank you all, it is a transaction log backup make it to smaller percentage of usage.

we have autoshrink off, and no shrink db jobs.

Thank you.

I will mark this post as a bookmark for my reference of memory option

So in my case, this server is 64 bits, and only 4 gb memory, it hosts...

Thank you.

I'm a little confused again. All our servers are 64 bits. And sometimes I heard from the forum microsoft recommend not changing the default settings for memory, and let...

Sorry, I meant it hosts databases for those applications and databases for sharepoints.

No application other than SQL server is installed on this server. All our SQL servers are designated box...

If all depends, this will not help.

It's impossible for us now to get another sandbox for us to play with, no budget for that, the server hosts 4 vendor...

Thank you.

I will try that.

I always wonder: does microsoft recommend using default memory settings OR is it good to allocate memory mnually like this?

Thanks

I should say it more clearer.

The box is only for SQL server, it hosts databases for diffrent applications.

So shall I allocate 1 gb to OS, and 3 to SQL server?

Thank you.

What I want to figure out is license issue. I don't have access to their PC to check out.

But I have a tool called Discovery that collects information through...