question

AntonyMaxwin-4065 avatar image
0 Votes"
AntonyMaxwin-4065 asked Cathyji-msft answered

Disk Size affected on slow performance of SQL

HI
I have one SQL server, and the server have C and D Drive , in c drive i have 750 GB free space, and the DB holding drive D drive has 3 TB space, but the free space is only 199 gb , Does it affect the slow performance of SQL,
can some body explain.

sql-server-generalwindows-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @AntonyMaxwin-4065,

Memory pressure can simply become an issue when the system doesn’t have enough RAM of SQL Server cannot allocate enough memory or more commonly poor database and query design. Lack of memory can also be caused by high I/O.

Dealing with performance problems is not an easy task but it all comes down to I/O, CPU, memory, or concurrency related stuff. Did you meet a SQL performance issue? If so, please using Performance monitor to monitor SQL server performance.

By the way, suggest you put SQL data files and log files to two different drivers when you have two drivers. Placing both data AND log files on the same device can cause contention for that device, resulting in poor performance. Placing the files on separate drives allows the I/O activity to occur at the same time for both the data and log files.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.