Post reply

Constant HD acitivity every 30 minutes blocks PC

  • January 19, 2006 at 2:23 am

    #89235

    Hello!

    When the SQL-Server services are started on my machine every 30 minutes SQL server blocks the laptop by constant HD activity on a data-File. This only occurs when the services are started. (WinXP, SP 2, DELL D505 Laptop, 1 GB RAM)

    Can anyone help and knows how to stop this?

    Thanks for your help!

    Jörg

  • January 19, 2006 at 2:48 am

    #615712

    How do you know it's SQL?

  • January 19, 2006 at 3:44 am

    #615729

    i'd suggest looking at sql agent. are you doing t-log backups every 30 minutes? is the laptop a subscriber (or publisher) for replication?

    MVDBA

  • January 19, 2006 at 6:51 am

    #615769

    Sorry, there are no jobs in the sql agent.

    Checked with File Monitor of sysinternals. When the Laptop is blocked the process sqlservr.exe is constantly reading on the file D:\Programme\Microsoft SQL Server\MSSQL\Data\jost.mdf.

    This is lasting for ca. 5 minutes.

    Any suggestions?

    Thank you!

  • January 19, 2006 at 6:55 am

    #615770

    Checked with File Monitor of sysinternals. When the Laptop is blocked the process sqlservr.exe is constantly reading on the file D:\Programme\Microsoft SQL Server\MSSQL\Data\jost.mdf.

    This is lasting for ca. 5 minutes.

    Any suggestions?

    Thank you!

  • January 19, 2006 at 7:44 am

    #615800

    OK so its definately SQL. Next step would be to put a trace on through SQL Profiler and see whats running on SQL.

  • January 19, 2006 at 8:29 am

    #615826

    Trace is running. Any particular EventClasses I need to monitor? I switched on all for now.

  • January 19, 2006 at 8:34 am

    #615827

    I would just sit back and wait until you notice the laptop getting hammered and then see what/who is hitting it.

  • January 20, 2006 at 6:23 am

    #616039

    Sorry, took a while but now I catched it:

    Event Class: SQL Transaction

    Object Name: Shrink File

    Duration: 10 to ca. 2000

    seems to be what blocks it.

    How do I prevent SQL Server form doing this?

  • January 20, 2006 at 6:28 am

    #616040

    In EM right mouse the DB in question -> Properties -> Options Tab -> Auto Shrink.

    You may need to do this on all DB's

    If you make new DB's check this setting on the model database, model is the 'blueprint' for any db you make.

     

     

  • January 20, 2006 at 7:19 am

    #616063

    I'll change this.

    THANK YOU VERY MUCH!

    Jörg

  • January 20, 2006 at 7:24 am

    #616067

    Lets hope it works!

    HTH

     

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

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