Forum Replies Created

Viewing 15 posts - 1,366 through 1,380 (of 1,640 total)

  • RE: CPU and memory monitor

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

    Thanks

  • RE: CPU and memory monitor

    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...

  • RE: I cannot find my previous post after change email address

    Thank you.

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

    Where can I find the other posts?

    Thanks

  • RE: some process is suspended and some is blocked.

    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

  • RE: monitor a database size

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

  • RE: monitor a database size

    How can I monitor the backup file size increase?

  • RE: monitor a database size

    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,...

  • RE: log file autogrowth report

    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.

  • RE: Memory

    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...

  • RE: Memory

    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...

  • RE: Memory

    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...

  • RE: Memory

    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...

  • RE: Memory

    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

  • RE: Memory

    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?

  • RE: analysis service client tool

    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...

Viewing 15 posts - 1,366 through 1,380 (of 1,640 total)