Friday, March 8, 2013

[MS SQL Server] Determine database grow per month

[MS SQL Server] Determine database grow per month


Determine database grow per month

Posted: 07 Mar 2013 06:59 PM PST

Is it possible to determinate how much disk space an specific database grow per month?in sql server 2008Any one advice me,, ThanksJerry

DB Restore - Stopping All Connections

Posted: 08 Mar 2013 02:46 AM PST

I'm working on database restores on a server and have run into some issues. We have multiple databases that are being slammed by applications at all points throughout the day. When doing a normal restore with "kill connections" through Redgate and/or SQL, the restores will fail about 50% of the time because of active connections. My new restore script is complicated but starts with setting each database to single_user. This has helped and now restores fail about 30% of the time but it's still not good enough.I have what I believe to be one of two options, either find all of the tasks/apps that hit our databases, which will probably be a couple day process, and stop those during the restores. Or find a good way to shut down all connections to the entire server except for the restore process. I'd prefer to do the later but don't know of a good way to do it automatically and through SQL Server. Can anyone help?Thanks.

Linked server

Posted: 07 Mar 2013 03:16 PM PST

Hi What is the linked server and how it will work?how can we connect or configure the linked server.can anyone please elaborate this because i am new to this

How can you issue a full backup and not interrupt the LSN's

Posted: 07 Mar 2013 02:38 PM PST

My two cents worth...I was reading an article the other day on junior dba questions and saw the question:How can you issue a full backup and not interrupt the LSN's?*Issue a copy only backup.(http://www.mssqltips.com/sqlservertip/1626/junior-sql-server-dba-interview-questions/)I have seen this answer many times and always thought it to be a half truth as I was a initially a bit confused about the role of copy_only backups when they first appeared and some answers mislead me a bit.To me it reads as though any full backup done outside the daily full backup will break the chain, or will be needed in order to restore to point in time (or the last log backup).Very happy to be corrected but is it true that the Log Chain is only interrupted by the full backup [b]IF [/b]the backup regime does Differential backups? If the backup regime only consists of a Full Backup and Log backups then you can do as many full backups as you want (and delete them) and the log chain will not be broken. i.e you can restore a backup from 6 months ago and restore to point in time as long as you can restore every backup log since in sequence -- regardless of continuing daily backups.thanks

Database Refresh

Posted: 13 Feb 2013 07:11 PM PST

Hi,What is the database refresh. how it will work.How to do the database refresh in sql server real time environment.Thanks in advance.

Database Timeouts : Error -2 Severity 11

Posted: 07 Mar 2013 09:34 PM PST

Hi Folks,at times with heavy workload, my devs tell me they receive a lot of database timeouts. A the database I got 2 stored procs which get heavily executed. If I run the queries at ssms they take about 1000 ms. The execution plan looks good. But the cpu goes up to 100% and I got a lot of SOS_SCHEDULER_YIELDS. I've allready gone through all the points of chapter 3 in the book "the accidental dba", but none of the reasosn fit. Why is the query so ressource intensive?

how to know the delta data volume processed every day in mb

Posted: 07 Mar 2013 05:57 PM PST

Hi I wanted to know if there is a way to figure out how many bytes of data have been processed while performing the delta on a table. I can easily get the delta count of every delta job run, but I'm not aware if there is a way to figure out how many bytes are processed based on the delta row counts or other. We use Informatica for our ETLs if this helps to get the delta data volume info.Please help and suggest of all possible ways to get this info.

No comments:

Post a Comment

Search This Blog