Browsing articles from "January, 2014"
Jan
1
2014

SQL Server CXPACKET waittype and MAXDOP settings – Tips

  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 […]

Jan
1
2014

Generate SQL Server Database Diagrams – tools tips

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 […]

Jan
1
2014

Database Backup Compression using SQL Server 2008 R2

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 […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 34 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

January 2014
M T W T F S S
« Oct   Apr »
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: