Post reply

tempdb space check on cluster

  • April 21, 2017 at 3:01 am

    #337327

    Hi Team,

    On a 2 node cluster how does one check the size of tempdb.

    Plz help on this

    Thanks

  • April 21, 2017 at 3:05 am

    #1939258

    Exactly the same way you would on any other server.  What "size" are you looking for - physical size of the log or data file(s), amount of data in those files, number of files, or something else?  Do you want to do this once, or regularly?

    John

  • April 21, 2017 at 3:12 am

    #1939261

    I'm looking at total size of temp db and the free space available

  • April 21, 2017 at 3:15 am

    #1939262

    You can use the in-built reports in Management Studio. Right click on the tempdb database in Management Studio -->Reports-->Standard Reports -->Disk Usage

  • April 21, 2017 at 3:18 am

    #1939263

    sp_spaceused should get you what you're looking for.

    John

  • April 21, 2017 at 3:32 am

    #1939265

    thank you for your prompt reply...
    what im trying to find out is that if there 2 nodes A and B

    I want to know what is the tempdb size in A and in B (free and total)

  • April 21, 2017 at 3:38 am

    #1939266

    Run sp_spaceused on A, then run it on B.  Use SSIS, linked servers or similar if you want to have it run centrally from a single point.

    John

  • April 21, 2017 at 3:38 am

    #1939267

    Have a look at the reports or run sp_spaceused on each node and instance you want the information for.

    Cheers

  • April 22, 2017 at 9:14 am

    #1939425

    thank you all for your help on resolving this

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply