The CPU, Disk and Memory are all OK, so is the network 2

Every month between 23 and 30, database access and response is very slow to and from the java...

No maintenance plan for rebuilding the indexes.

I have tried to shrink the MDF files without any progress.

I used both DBCC shrinkdatabase(MyDB, TRUNCATEONLY) and also DBCC Shrinkfile(MyDB,20480)

However, shrinking the Transaction Log...

Hi,

I dont think my MDF file (46GB) is actually holding that much information.

Why? Cause my Recovery Model is FULL and my LDF file is now under 5MB

First why do you...

Database Recovery Model = Full

Yes, Transaction log backup are being taken via Maintenance job and its now down to less than 36MB

But the Data file is still between 40 and...