Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brave324
Starting Member
3 Posts |
 Posted - 2012-01-12 : 02:05:43
|
| Hello,I'm getting 100% disk highest active time for 10 second bursts with gaps of 10 seconds caused by sqlserver.exe and I don't know the steps to determine what is causing the problem. The db is for a .net web application and doesn't happen instantly on app start. If I restart the app it will reoccur after 5 minutes or so and continue indefinitely. Starting at 1,000,000 B/min read and 0 B/min write and when the problems begin moving up to 400,000,000 B/min read and 600,000,000 B/min write. The write is the most bizarre because almost no queries are being run that write to the db.I've used server profiler and can't find any problem queries.Is there somewhere I can a breakdown of the B/min read and writes for the db? |
|
|
brave324
Starting Member
3 Posts |
Posted - 2012-01-12 : 06:54:18
|
| Just noticed it's the tempdb.mdf files with the high read/write not my database file. I'm not creating an temp object that should pose a problem that I know of. Do you know of a way to determine what tempdb is doing to cause the read/writes? |
 |
|
|
biswajitdas
Starting Member
44 Posts |
Posted - 2012-01-12 : 16:29:59
|
| 1) Please check the disk where you keep the database file (MDF , LDF) , may be you can take help of your window adminstrator to verify the hard disk or SAN is ok .2) check the McAfee scan , or virus scan installed in your production machine . Virus scan should exclude your (mdf,ldf,ndf) file.3) as you said its a web application checjk with your network team about the network card and communication with the server.we will go more detail if all the above dont find any resultSr Sql server DBA/Artitech |
|
|
|
brave324
Starting Member
3 Posts |
Posted - 2012-01-12 : 16:48:21
|
| I added another mdf file of the same size to the tempdb on another disk and it seems to have fixed the problem. I don't know what the cause was however. |
|
|
|
|
|
|
|
|
Highest Active Time 100% cyclical