database high usage RRS feed

  • Question

  • Dear All, I observed suddenly 1005data file usage on our database.By mistakenly application team ran the application in bothe primary and secondary servers.They are adding new data to that databse also. Note:In secondary server(which using as backupserver)database was increased. Kindly need some suggetions.
    • Edited by mito access Friday, August 6, 2010 8:43 AM hh
    Friday, August 6, 2010 8:42 AM

All replies

  • I didnt understand your problem exactly but if database usage is high you can check for process causing this
    http://rknairblog.blogspot.com/ http://ratheeshknair.wordpress.com/
    Friday, August 6, 2010 11:45 AM
  • Hi mito,


    How did you observe the data file usage? Which version of SQL Server are you using? What is the result of “SELECT @@VERSION”?

    Monday, August 9, 2010 12:33 PM