Viewing 5 posts - 1 through 5 (of 5 total)
There are 2 other large archival (reporting) databases on the server that are located on different SAN drives. They have been tuned and are not having performance issues.
January 11, 2017 at 3:20 pm
The server has 64 logical processors. 20 is a bit of overkill but not much.
Stats are updated nightly. Indexes are defragmented nightly.
Performance issues are truly caused...
January 11, 2017 at 2:34 pm
The tempdb has 20 datafiles and no symptoms of contention.
The application database has extensive patch latch waits (due to table scans).
January 11, 2017 at 2:09 pm
I placed the database file on the SSD drive with 5 minute transaction log backups to a san drive.
A manager from another dept. told my manager that placing the...
January 11, 2017 at 1:26 pm
SSD drive is 1.5 TB
Database is 50 GB
tempdb is 85 GB. Last week it filled up and crashed the server.
The database has performance issues due to table scans in...
January 11, 2017 at 11:01 am
Viewing 5 posts - 1 through 5 (of 5 total)