The SURMA Occasion
The SURMA in regards to SQL Server is nothing but we can perform the same occasionally....
- Search for important errors in logs to find the solution.
- Update Statistics sometime required to be executed to resolve the performance issue quickly.
- Reviewing Maintenance Logs.
- Maintenance DBCC during off hours.
- Activity Monitor to find any bottleneck.
{
Topics
Update Statistics
Port 1433,
WaitTypes
Editions & Versions
}
[Other Topics
Single User Mode
Tables without clustered indexes are called?
Max Worker threads, NDF vs MDF, Error logs and CXPACKETS
Internal waittypes
SATELLITE_CARGO
FT_IFTS_MASTER_MERGE_TASK_LIST
FABRIC_REPLICA_PUBLISHER_SUBSCRIBER_LIST
HADR_DATABASE_WAIT_FOR_RECOVERY
Ability to improve Query execution time
Concatenation
https://learn.microsoft.com/en-us/sql/mdx/concatenation-operators?view=sql-server-ver16
]
Any query will be considered.
T. Amit Vaid S.
No comments:
Post a Comment