Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Lazy Writes / sec

    Found the answer to my own question.

    Yes it is as i suspected. It is incremental. So if someone would like to get this value you should run:

    declare @LazyPerSec bigint

    SELECT @LazyPerSec...

  • RE: Row count per filegroup

    thanx

    I got a script that gives you all rows per filegroup in case someone needs it

    SELECT

    DB_NAME() AS 'DatabaseName'

    ,OBJECT_NAME(p.OBJECT_ID) AS 'TableName'

    ,p.index_id AS 'IndexId'

    ,CASE

    WHEN p.index_id = 0 THEN 'HEAP'

    ELSE i.name

    END AS 'IndexName'

    ,p.partition_number...

  • RE: Initial size for TempDb data and Log file?

    Never ever use % on log file or DB...

    I just had my first problem with that. I have 2 companies with the same software that we provide and both have...

Viewing 3 posts - 1 through 3 (of 3 total)