Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Find Login in Active Directory

Find Login in AD

Many times we require to know if particular login is a part of ad user group. Or sometimes we need to know a AD group and wanted to know who all logins are part of it.

There are many different ways to achieve this.

  1. I follow…

Read more

1 comments, 119 reads

Posted in Vinay Thakur on 29 January 2012

When Date Modified changes for Sql mdf/ldf files

*This is related to physical file size of a MDF or LDF file not internal allocation.

One of our user asked that the ldf file is not changing, on checking the last modified date time, user was asking this.

Its a good question, the we have to educate to user… Read more

0 comments, 11 reads

Posted in Vinay Thakur on 18 January 2012

Good Bye 2011

Good Bye 2011

Hey there, this year is going to an end and just want to recall what all happened this year in my life both personally (cannot disclose much J) and professionally.

The good news about this year is on 24th Dec 2011, we blessed a second… Read more

0 comments, 4 reads

Posted in Vinay Thakur on 31 December 2011

Basics QA on Extended Event

Basics QA on Extended Event

 

 

I am learning Extended Event so this is my first blog on extended event, There is a great whitepaper on XEvent by Jonathan Kehayias.

Q1. What is extended event?

A1. It is a light weighted profiler kind of trace introduced on sql… Read more

0 comments, 10 reads

Posted in Vinay Thakur on 23 December 2011

Suspect Database

Suspect database generally caused by internal IO issue, and the best way to resolve it to ask hardware person to check and correct the issue. And sql server dba has to monitor it.

Check the database consistence using

DBCC CHECKDB (‘YourDBname’) WITH NO_INFOMSGS, ALL_ERRORMSGS

And try to understand the messages. Read more

0 comments, 6 reads

Posted in Vinay Thakur on 19 December 2011

spid in Killed/Rollback cannot kill

We come across a situation where we have to kill one spid which was running for quite some time, so we though killing will help us, but after killing found that that spid is not killed but stuck in our processes spid. And we could not able to kill even Read more

0 comments, 11 reads

Posted in Vinay Thakur on 17 December 2011

Download: Troubleshooting a day – Nov 2011

As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here. I have done this month as well, I Blog about Troubleshooting sql server issues -Errors , which we get during our day to day activity.

you can download… Read more

0 comments, 5 reads

Posted in Vinay Thakur on 30 November 2011

Day 30: More Fatal Errors and BUGs

Day 30 More Fatal Errors and BUGs

  1. For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record  structure(for sql server 2005 onwards you may get 824).

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database… Read more

0 comments, 6 reads

Posted in Vinay Thakur on 30 November 2011

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Description:-

Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user database has grown high and occupying most of its space. Please see the great blog post to know about what is log and how log file works here by… Read more

0 comments, 7 reads

Posted in Vinay Thakur on 29 November 2011

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

  1. Error 823: IO error OS cannot read the data

Error: 823, Severity: 24, State: 2.
The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset xxxx in file ‘xxx.mdf’. Additional messages…
Read more

0 comments, 8 reads

Posted in Vinay Thakur on 29 November 2011

Day 28: Linked server errors

This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011             Day 28: Linked server errors Linked server is another good linking took where you can linked the server access the data from different … Continue reading

Read more

0 comments, 5 reads

Posted in Vinay Thakur on 28 November 2011

TransactionLog Internals

Transaction Log : >> Transaction log is tracks transaction on that database. >> There should be at least one  transaction log (ldf) file for every database, >> Transaction log is always write in sequential manner , Only at redo state … Continue reading

Read more

0 comments, 105 reads

Posted in Vinay Thakur on 22 June 2011

Difference between Checkpoint and LazyWriter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk 1. Flush dirty pages to disk. 2. Flush only Data pages to disk 2. Check for available memory and removed … Continue reading

Read more

0 comments, 129 reads

Posted in Vinay Thakur on 20 June 2011

Difference between Checkpoint and LazyWritter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk 1. Flush dirty pages to disk. 2. Flush only Data pages to disk 2. Check for available memory and removed … Continue reading

Read more

0 comments, 28 reads

Posted in Vinay Thakur on 20 June 2011

How Query execute

*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from disk(file). Select : The command will go to relational engine and create a query plan for the same. –compile plan … Continue reading

Read more

0 comments, 33 reads

Posted in Vinay Thakur on 10 June 2011

Isolation level and Locks

Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends on isoalition level the level of isolation are as 1. Uncommitted Read (NoLock) 2. Committed Read (blocking) 3. Repeatable Read (phantom) … Continue reading

Read more

0 comments, 151 reads

Posted in Vinay Thakur on 8 June 2011

Failure Cluster -General

We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”) and realized that I have not blog much about clustering, Here I will be considering 2 node clustering “Active -Passive” … Continue reading

Read more

0 comments, 47 reads

Posted in Vinay Thakur on 4 June 2011

SQL Server Migration Assistant v5.0

I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA for Access v5.0 2. SSMA for MySQL v5.0 3. SSMA for Oracle v5.0 4. SSMA for Sybase v5.0 Ref: http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx

Read more

0 comments, 30 reads

Posted in Vinay Thakur on 25 May 2011

Troubleshooting Performance -1

Whenever you get a call from user that they are facing any performance issue what would you do. As I blog earlier on this, we should follow the top down approach where we need to see the scenario from bigger … Continue reading

Read more

0 comments, 42 reads

Posted in Vinay Thakur on 11 May 2011

Download: Powershell a Day -April 2011

I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can download the consolidated pdf file which contains all the 30 days blog post. Download the file from here

Read more

2 comments, 37 reads

Posted in Vinay Thakur on 30 April 2011

Older posts