Forum Replies Created

Viewing 15 posts - 61 through 75 (of 112 total)

  • RE: TempDB data file is Huge

    hi go to http://www.sqlservercentral.com/Forums/Topic910208-146-1.aspx there are a few techniques in the link to check whats up with the tempdb.

    If you searched on this forum you would have picked up...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 28, 2010 at 2:32 am

    #1173782

  • RE: Tempdb GROWS

    I just used the Standard (Default) template ... and populated a table with the results to query it.

    Just for some extra info, this DB SQL2005 Instance (Default) is on SP3

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 13, 2010 at 12:56 am

    #1166663

  • RE: Current queries running on Tempdb

    Try this http://www.sqlservercentral.com/articles/Log+growth/69476/ and let it run every 5 min.

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 13, 2010 at 12:53 am

    #1166660

  • RE: Tempdb GROWS

    Profiler Gui ... the TextData column has the sql text in it ...

    I'm awaiting response from the vendor but every response thus far are 1 liner emails :ermm: :ermm:

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 12, 2010 at 2:20 am

    #1166006

  • RE: Tempdb GROWS

    just to add to that, the free space in the tempdb

    @ 02:20 = 37.4Gb

    @ 02:30 = 34.4Gb

    @ 02:40 = 30.8Gb

    @ 02:50 = 25.6Gb

    @ 03:00 = 18.8Gb

    @ 03:10 = 9.2Gb

    @...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 11, 2010 at 7:18 am

    #1165521

  • RE: Tempdb GROWS

    I got up @ 2AM to start the trace and will post the top 5 reads and writes queries which IS NOT NULL TestData in the Trace table 1Gb in...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 11, 2010 at 4:16 am

    #1165431

  • RE: Tempdb GROWS

    re created the current indexes, we didn't add any new indexes

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 11, 2010 at 3:44 am

    #1165420

  • RE: Current queries running on Tempdb

    another tempdb growth issue, this is just on the log file where as mine is on the datafile. Do you know +- what time the issue is happening? I intend...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 10, 2010 at 7:42 am

    #1164980

  • RE: Tempdb GROWS

    I ran the query this morning when I saw your post.

    The time the Tempdb grows or grew let me rather say is from 02:17 AM until 03:45 AM.

    I'll create a...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 10, 2010 at 6:13 am

    #1164921

  • RE: Tempdb GROWS

    CirquedeSQLeil (5/7/2010)

    Run this query and post the results

    SELECT top 5 *

    FROM sys.dm_db_session_space_usage

    ORDER BY (user_objects_alloc_page_count +

    internal_objects_alloc_page_count) DESC

    9424400

    5721100

    6721100

    620000

    520000

    The Tempdb file is 38.3Gb and the log file is 386Mb...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 10, 2010 at 1:13 am

    #1164846

  • RE: Tempdb GROWS

    Will do, I'm going throw the whole thread again and checking all the suggestions again.

    Thanks again.

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 7, 2010 at 6:51 am

    #1164038

  • RE: Tempdb GROWS

    Hi I implemented what the article CirquedeSQLeil suggested. It ran for 2 days and in a previous post is what I found.

    I ran the Query MANU-J posted ==> most IO...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 7, 2010 at 6:26 am

    #1164010

  • RE: Tempdb GROWS

    Hi this is the vendor's query, it takes from 3min to over an hour from start time to insert time!

    So you saying the waits are nothing to worry about...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 7, 2010 at 5:57 am

    #1163976

  • RE: Tempdb GROWS

    Hi guys on the 5th, we stopped the Solarwinds application, we restarted the SQL service to flush out the Tempdb and started this app which ran every 5 min. I...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 7, 2010 at 4:15 am

    #1163920

  • RE: Tempdb GROWS

    CirquedeSQLeil (4/30/2010)

    I suggest to find what is causing it to be that big. Gianluca proposed a solution. I'll propose another option - read this article[/url] and try it's...

    MCITP: Database Administrator 2005
    MCTS SQL Server 2008
    MCP SQL 2012/2014
    MCSA SQL Server 2012/2014
    MCSE Data Management and Analytics

    May 4, 2010 at 7:16 am

    #1161768

Viewing 15 posts - 61 through 75 (of 112 total)