Recently while troubleshooting performance issue on a server, found that the CXPACKET waittype is high,   WaitType Wait_S Percentage AvgWait_S AvgRes_S AvgSig_S CXPACKET 1402132.06 56.82 0.0067 0.0063 0.0004   CXPACKET waits in the server are not an immediate sign of problem; they may indicate another problem, associated with one of the other high value wait types in the instance for e.g. Queries are executing with parallelism   Now when dealing with CXPACKET waittype do […]

Came across a requirement where I need to generate database component chart and their relationships, though database diagram tool is available but it has some risks associated, hence just in order to generate component chart, third party tools are also available and can server purpose, below is just collection of such tools and related links for use of needy ones,     Using inbuilt Database Diagram Tool: Just right Click on Database Diagrams and create […]

Database backup compression is a feature provided by Microsoft which reduces the native backup size by up to 66% depending upon the type of data stored in a database and similar other factors. By default backup compression is disabled as it has some limitations which needs to be looked as per environment setup and if suites one’s need then it can be enabled as default or a parameter can be added to backup script to […]