163 reputation
9
bio website avakharia.com
location
age 30
visits member for 1 year, 10 months
seen Mar 14 at 2:31

A curious web developer, junior DBA and an ethical hacker.


Sep
24
awarded  Autobiographer
Apr
16
awarded  Popular Question
Jun
17
comment Configure SQL Server Database for High Availability & Warehousing
I'd rather keep the mirroring instance separate from reporting as I do have 3 DB servers. And plus there are more databases that I'll be mirroring eventually. I'll look into snapshot/replication. Thanks for sharing.
Jun
17
revised Configure SQL Server Database for High Availability & Warehousing
added 60 characters in body
Jun
17
comment Configure SQL Server Database for High Availability & Warehousing
Just posted a comment below. It can be up to a day behind. But I'll update the original question too.
Jun
17
comment Configure SQL Server Database for High Availability & Warehousing
Reporting instance doesn't need to be real time but one day lag is acceptable. While doing log shipping to create the reporting DB, it increases the log file disk space to be as much as the database size sometimes and that has created problems for us with not enough storage on the disk. That's why doing transaction log backup's would not allow the log file to grow that big. I haven't looked in to snapshot replication but I'm open to it. If you can share some articles or way of doing it, that will be helpful.
Jun
17
asked Configure SQL Server Database for High Availability & Warehousing
May
17
comment Copy tables from a stand-by database
Just use management studio's import/export wizard and it will take care of creating the tables and importing data. You might want to disable referential integrity constraints if any.
May
17
comment Installation of SQL Server RAID 10 vs RAID 5
I agree with Aaron. We moved from RAID5 to RAID10 a year or so ago and have seen dramatic improvements in writes as well as reads.
May
16
comment Total Memory used by SQL Server (64 bit)
That's true. How about using 'dbcc memorystatus' and parsing the data using Powershell - blogs.msdn.com/b/timchapman/archive/2012/08/16/…
May
10
comment Total Memory used by SQL Server (64 bit)
I use this to track physical memory for my databases. ------------------------------------------------------------------------- SELECT total_physical_memory_kb, available_physical_memory_kb, total_page_file_kb, available_page_file_kb, system_memory_state_desc FROM sys.dm_os_sys_memory WITH (NOLOCK) OPTION (RECOMPILE);
May
10
comment How do I determine if a database is the principal in a mirroring setup?
What difference does it make if I query sys.databases or sys.database_mirroring?
Mar
29
revised sql server-percentage calculation
added 1218 characters in body
Mar
21
answered sql server-percentage calculation
Mar
20
awarded  Informed
Mar
19
answered How do I determine if a database is the principal in a mirroring setup?
Mar
19
answered In what data type should I store an email address in database?
Jan
30
answered SQL Server Database Synchronization
Jan
30
awarded  Commentator
Jan
30
comment SQL update satement taking a very long time / high disk usage for hours
It looks like the index/data on that ID is corrupted. This link might be helpful in figuring it out: simple-talk.com/sql/database-administration/…