Tag Archives: Administration

SQL Server Production Issues

SQL Server Production Issues Prod Problems and Solutions:      Below are the common problems from production environment.  SQL Server Log full alert  SQL Server Blocking Alert Low Disk Space/Disk Full       Now here are the solutions for these issues…………….    SQL … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , , , | 3 Comments

Static and Dynamic port in sql server

Static and Dynamic port in sql server STATIC PORT ALLOCATION If you configure an instance of SQL Server to use a static port, and you restart the instance of SQL Server, the instance of SQL Server listens only on the … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , | 2 Comments

Dynamic Management Views in Sql Server

Dynamic Management Views in Sql Server Introduction: The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what’s going on inside SQL Server. They can provide information on what’s currently happening inside the … Continue reading

Posted in SQL Development, SQL Server DBA | Tagged , , , , , , , | Leave a comment