bird's eye view over SQL Server Performance

-
There is good statement that you can see what is going on Database
DBCC SQLPERF('waitstats')
it collects wait status group by Wait Type.

Comments

Post a Comment

Popular posts from this blog

New Journey : Linux in Windows and containerization through Docker Desktop for Windows

-
Image
 Hello, I got closer to Ubuntu Linux distributon while investigating a product top of Linux kernel during my new project involvement. As I do not want to create Virtual Machine and install  Linux to there, I focused on possibilities to use Windows OS itself  so Windows Subsystem for Linux feature of Windows Operating System Family came up as a solution. Apart from that I needed to setup conteinariztion for Windows to download dependent distributions of the product what i was looking for. Terminology before start: Windows 10 is a series of operating systems developed by Microsoft and released as part of its Windows NT family of operating systems. It is the successor to Windows 8.1, released nearly two years earlier, and was released to manufacturing on July 15, 2015, and broadly released for the general public on July 29, 2015. Ubuntu is a Linux distribution based on Debian mostly composed of free and open-source software. Ubuntu Server is a server operating system, devel...
Read more

Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in CrmServiceHelper.cv

-
Hello, I faced an error when i iniated configuration class of CrmServiceHelper of Microsoft in order to setup Dynamics 365 Customer Engagement (Dynamics CRM online) SDK connection. The mesage was " Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified. " Here is the fix: Open NuGet Package Manageer froom Tools view in Visual Studio and make an online search for System.ServiceModel.Primitives finally install it to the project. enjoy... Muhammet Atalay
Read more

Installation of Microsoft Visual C++ Runtime failed. Exit code: 5100. Result: Asia in Microsoft Dynamics CRM 2011

-
If you face an error about Installation of one or more missing prerequisite components while installing Microsft Dynamics CRM 2011 server (i met some consultants who get same error while installing CRM for Outlook Client).it is related with version of Microsoft Visual C++ Redistributable package running on the server. Here is the story of me; I wanted to try install Microsoft Dynamics CRM 2011 into Microsoft Windows 2008 R2 x64 Enterprise server which has already Microsoft SQL Server 2012 Developer Edition. I got an error during installing prerequisite. I checked logs from "C:\Users\Administrator\AppData\Roaming\Microsoft\MSCRM\Logs\crm50svrsetup.log" and found; 11:18:45| Info| CmdLine: <"D:\Redist\VcRedist\vcredist_x64.exe" /q /norestart> 11:18:45| Info| WorkingDir: 11:18:53| Info| Installation of Microsoft Visual C++ Runtime failed. Exit code: 5100. Result: Asia 11:18:58| Error| Installation of one or more missing prerequisite c...
Read more