none
Desempenho do banco RRS feed

  • Pergunta

  • Boa tarde,

    gostaria de uma ajuda, tenho um servidor com XEON 2.50 GHZ, 48 GB de RAM, 2 HDs SSD V300, mas, estou tendo uma lentidão muito grande no meu banco, verifiquei pelo Monitor que esta rodando automaticamente uma query no TEMPDB, abaixo segue, alguem sabe o que é? E será que é o que está causando está lentidão? Pois até dois dias estava rápido as coisas.


    SET NOCOUNT ON;

    DECLARE @previous_collection_time datetime;
    DECLARE @previous_request_count bigint;
    DECLARE @current_collection_time datetime;
    DECLARE @current_request_count bigint;
    DECLARE @batch_requests_per_sec bigint;
    DECLARE @interval_sec bigint;

    -- Get the previous snapshot's time and batch request count
    SELECT TOP 1 @previous_collection_time = collection_time, @previous_request_count = request_count 
    FROM #am_request_count
    ORDER BY collection_time DESC;

    -- Get the current total time and batch request count
    SET @current_collection_time = GETDATE();
    SELECT @current_request_count = cntr_value 
    FROM sys.sysperfinfo
    WHERE counter_name = 'Batch Requests/sec' COLLATE Latin1_General_BIN;

    SET @interval_sec = 
        -- Avoid divide-by-zero
        CASE
            WHEN DATEDIFF (second, @previous_collection_time, @current_collection_time) = 0 THEN 1
            ELSE DATEDIFF (second, @previous_collection_time, @current_collection_time)
        END;

    -- Calc the Batch Requests/sec rate for the just-completed time interval. 
    SET @batch_requests_per_sec = (@current_request_count - @previous_request_count) / @interval_sec;

    -- Save off current batch count
    INSERT INTO #am_request_count (collection_time, request_count) 
    VALUES (@current_collection_time, @current_request_count);

    -- Return the batch requests/sec rate for the just-completed time interval. 
    SELECT ISNULL (@batch_requests_per_sec, 0) AS batch_requests_per_sec;

    -- Get rid of all but the most recent snapshot's data
    DELETE FROM #am_request_count WHERE collection_time < @current_collection_time;

    sexta-feira, 21 de agosto de 2015 16:15

Respostas

Todas as Respostas