Skip to content

Sri

Hello Friends, This blog is to help the IT professionals who want to become a professional SQL Server DBA but don't know how and from where to start with. So, I am going to share my experiences and my learning in this blog. Will talk about what are the pre-requisite skills required to become a Professional SQL Server DBA, how much time it takes to be a good DBA and what are the additional skill sets are required to become a good DBA. Apart from that I will also post real time sql server settings on server level and database level, Configuring High Availability. Also will share the Client requirements with real time setups if possible I will provide you with screenshots.

SQL High CPU Utilization Troubleshooting

  • by

Microsoft recommends the following CHECKLIST POINTS: Process (sqlservr): % Privileged Time % Processor Time % User Time SELECT s.session_id, r.status, r.blocking_session_id ‘Blk by’, r.wait_type, wait_resource,… Read More »SQL High CPU Utilization Troubleshooting