16,126 reputation
11248
bio website sqlsybase.azurewebsites.net
location New York, United States
age
visits member for 2 years, 5 months
seen 5 mins ago

I am a Sr.SQL Server and SybaseASE DBA working for a company that makes software for Investment Banks globally as well as does Hosting business. I love working on performance tuning, migration, baselining, process automation, Cloud (Azure), High availability as well as Disaster recovery technologies, etc. I firmly support SQL Server community and so being on this site is my way of gently giving back to the community of what I have earned over the years.


37m
comment Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
@AndrewSehr what is the MAXDOP setting on the instance ? There might be other stuff running at the same time causing blocking as well. Can you share the actual execution plans for top 10000 vs top 100000 ?
1h
comment How to check SQL database files for physical fragmentation?
Thats a knee jerk approach. I would suggest to look at the wait stats, locking / blocking by running sp_whoisactive or sp_askBrent. Also read on Stop Worrying About SQL Server Fragmentation
2h
comment How to check SQL database files for physical fragmentation?
Do you have any evidence that physical fragmentation is causing problems ?
17h
comment work/cache table issues, heavy inserts with heavy reads
Couple of questions - when you say during the updates, we delete all the previous info - are you wiping out all the data or just a subset ? What isolation level you are using ? How are you doing inserts - BULK LOAD, SSIS, SELECT .. INTO ?
18h
comment What should I monitor on the SQL Server machine?
possible duplicate of How to get server cpu, memory, network usage from SQL Server
1d
revised Can I stop a SQL database backup after it has already started?
added 952 characters in body
1d
answered Can I stop a SQL database backup after it has already started?
2d
comment what is running VSS on my server
Yes I meant server side trace within SQL Server. If you want to track on OS level, I would recommend using sysinternals process explorer.
2d
comment what is running VSS on my server
Kick off a server side trace. That will tell you who is doing what. Make sure to filter by the stuff that you only need.
2d
reviewed Close CLOB data type is not working as expected
2d
reviewed Close Running more than one copy operations in IBM Datastage in a single job
2d
reviewed Close Peer to peer replication error
2d
reviewed Close How to pass Parameters to stored procedure with input parameters from checkboxes
Oct
19
awarded  Popular Question
Oct
17
comment How to set a restart on a TSQL Job?
Why would a job get hung ? It has to do with some blocking or some problem with the job logic. Please provide more details. Alternatively, you can run sp_whoisactive and see what it is doing ? sys.dm_os_waiting_tasks will tell u why it is waiting.
Oct
16
comment Log shipping option not showing
Do you have proper permissions?
Oct
16
comment ASSIGN value for cmd in sysprocesses? What does it mean?
Sp_whoisactive to the rescue. Run it and save the output to table for further analysis. Alternatively, you can use event notification with blocked process report as well.
Oct
15
revised How to use COLLATE with UNION
deleted 3 characters in body
Oct
15
revised SQL Server mirroring causing issues
added 6 characters in body
Oct
15
comment “Could not insert a backup or restore history/detail record in the msdb database” While restoring msdb
Different errors. Can you try restoring on a different server and take full and log backups? Something is not right - io subsystem may be ?