I was getting wait type PREEMPTIVE_OS_WRITEFILEGATHER during database size allocation. Yesterday, I was configuring database size to the value that was suggested by the vendor. We need to set database size to 700GB keeping 150 GB to log files. I...
Have you even face that your transaction log file is growing exceptionally and you have to manage log file to make it in his size limit? Managing transaction log file is not an easy job if you have to run...
Find the second part of vra interview questions and answers in this article. You can read first part of vra interview questions and answers in attached link. Visit this website frequently or subscribe us to get more vRealize Automation interview...
Last week I was working on SQL Server installation where i got this error Attributes do not match. Error details of that issue are given below: Microsoft.SqlServer.Configuration.Sco.DirectoryAttributesMissmatch: Attributes do not match. Present attributes (Directory, Compressed, NotContentIndexed) , included attributes (0),...
Today, a user has raised a request to fix an error (Microsoft SQL Server Error 40 – Could not open a connection to SQL Server or Microsoft SQL Server, Error 2) he was getting while establishing the database connection. Sometimes you might...
DBCC SQLPERF is very useful command that we use to get multiple statistics related information in SQL Server. This command provides transaction log space statistics and wait statistics information at instance level and we also use it to reset wait and...
Resumable Online Index Rebuild is a new feature introduced in SQL Server 2017. Index Rebuild operation is very expensive task that takes lot of system resources and log spaces during execution. Sometimes, we need to cancel index rebuild operation in...
Here, we are going to talk about disk and performance Impact of online Index rebuild operation. As we know index rebuild is offline operation due to which indexes become inaccessible. Here, I will describe about SQL Server rebuild index online...
Should we clear or reset Performance Wait Statistics Data present in DMV sys.dm_os_wait_stats in SQL Server? The answer to this question is depends on case to case. Ideally, you should not clear your wait statistics data frequently. Best way is Do Not clear wait...
Sometimes, cursor or mouse pointer does not visible on your putty terminal console. The reason behind that is cursor color and putty background color are set to same color configuration. You will not be able to see putty cursor or...
If you want to change putty background color from black to white or any color as per your choice then you should keep reading this article. If you are working for several customers, you can configure distinct colors for their...
If you want to change PuTTY text color that are more visible to your eyes and make you understand what is written on your putty console then you should keep reading this article. We should always set text colors that...
Yesterday, a developer has reported an SQL Server error 18456 Login failed for user ‘username’. (Microsoft SQL Server, Error: 18456) on one of the SQL Server instance that are running in lower life cycle. The details about SQL Server error...
Password change is a routine task to keep your login secure. We use passwd tool on most of the Linux operating systems to change user password. The passwd tool changes passwords for user and group accounts, even you can change your...
Today I am going to discuss about Microsoft SQL Server Error 28 that most of the SQL Server users might have faced at least once in their career. It belongs to SQL Server connectivity issue SQL Network Interfaces Error 28....
