Method 1:
- Set initial size using the SQL Management Studio GUI.
- Restart the SQL Service
- New sizes should be set.
Method 2:
- The best way to solve an issue is to avoid it.
- If we want to restart the SQL service and start it with switches then the correct way to do it will be using the SQL Configuration Manager.
Starting the SQL from the command prompt (specifically with the minimal configuration switch) will cause to the server spn to be attached to the user running the command and will NOT be reverted to the original user.
(Next post will covert the issue of "How to fix server spn") - TempDB file sizes should be set once with the same values for the initial size and for the max available size and without auto grow.
- TempDB Database should have it's own driver and it should fill it to the max.
- Must cases that the TempDB will try to increase it's size it will be due to a query that is spiraling out of performance (due to bad query, wrong input ect')
כתיבת תגובה