17,256 reputation
21760
bio website sqlsybase.azurewebsites.net
location New York, United States
age
visits member for 2 years, 6 months
seen 6 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.


22h
revised How to pass output of one stored procedure to the input of another
added 48 characters in body
1d
answered Moving a SQL Server TempDB of AlwaysOn members
1d
comment Moving a SQL Server TempDB of AlwaysOn members
You can use ALTER DATABASE tempdb MODIFY filename on both secondary and primary. Then restart SQL service on secondary. If you have a downtime window, restart SQL service on primary during that time or you can failover to secondary and then restart SQL service on primary.
2d
answered Granting permission on a particular job to execute on SQL Server 2005
Nov
22
comment Query execute slowly when changed compatibility Level of my database
Did you recompile the stored procedure using sp_recompile ?
Nov
21
reviewed Approve suggested edit on Joining Multiple Tables in Sql Query
Nov
21
awarded  Nice Answer
Nov
21
comment How can I check for stored procedure consistency across multiples servers
+1 learned about some new tool.
Nov
21
comment There is insufficient system memory in resource pool 'internal' to run this query
@aa.sc that's fine. I just pointed out what would fix it as in some shops SQL servers are version and service pack dependent. Latest SP is a better choice.
Nov
21
awarded  Enlightened
Nov
20
comment SQL Server spending a lot of time creating sp_dbmmonitorupdate
msdb.dbo.dbm_monitor_data comes from - If you are running database mirroring monitor or have SQL Agent job that is created by the database mirroring monitor enabled. You should disable it and use DMVs instead sys.database_mirroring.
Nov
20
awarded  Nice Answer
Nov
20
awarded  Nice Answer
Nov
20
comment AlwaysON : Log_Send_Queue_Size is increasing but the log_send_rate keeps decreasing?
Seems like we might be hitting Longer latency for SQL Server 2012 database when you use Service Broker, database mirroring, and Availability Groups. This is fixed in SQL server 2012 SP2 CU1. The KB 2976982 has a typo(AlawysOn). So if you are searching by AlwaysON, it wont show up :-(
Nov
20
comment There is insufficient system memory in resource pool 'internal' to run this query
@AA.SC You might be hitting a bug that is fixed in SQL Server 2008 R2 CU4
Nov
20
comment There is insufficient system memory in resource pool 'internal' to run this query
@AA.SC Do you have fulltext running ?
Nov
20
comment There is insufficient system memory in resource pool 'internal' to run this query
What is total RAM and max memory configured? Seems to me an issue with the query pulling massive amount of data - memory grant issue.
Nov
20
comment SQL agent jobs appear as job id only
@user41868 Even though too late to the party, please see my answer. Thanks.
Nov
20
answered SQL agent jobs appear as job id only
Nov
20
answered Notification when the status on sql server replication is “Not Running”