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

Articles with tag administration Rss

Search for any content tagged administration

<< Newer    Items 41 to 60 of 801    Older >>

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 10,492 reads

What Counts for a DBA: Being Replaceable

Louis Davidson describes why all DBAs should strive to be replaceable, and what that really means.  Read more...
By Louis Davidson (@drsql) 2012/12/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 219 reads

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.  Read more...
By Additional Articles 2012/12/05 | Source: | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,848 reads

Has tempdb grown since the last restart?

Check tempdb to see if it has been autogrown since the last restart. If it has, there may be an opportunity to improve server performance.  Read more...
By Orlando Colamatteo 2012/11/20 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 7,951 reads

Viewing VMware Counters in PerfMon for SQL Server

I want to ensure that my SQL Server on a VMware Guest OS is getting the resources it should. This would go a long way towards helping isolate the performance problems we're experiencing. However, our system administrators won't give us access to VirtualCenter or any of the tools they use. Is there anything I can do? Check out this tip to learn more.  Read more...
By Additional Articles 2012/11/12 | Source: | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 2,428 reads

Manage By Delegation

There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.  Read more...
By Steve Jones 2012/10/17 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 119 reads

Check SQL Server Virtual Log Files Using PowerShell

In a previous tip on Monitor Your SQL Server Virtual Log Files with Policy Based Management, we have seen how we can use Policy Based Management to monitor the number of virtual log files (VLFs) in our SQL Server databases. However, even with that most of the solutions I see online involve the creation of temporary tables and/or a combination of using cursors to get the total number of VLFs in a transaction log file. Is there a much easier solution?   Read more...
By Additional Articles 2012/10/11 | Source: | Category: administration
Rating:  Rate this |   Briefcase | 2,839 reads

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,268 reads

The DBA Database

One very handy item Steve Jones found as a DBA was a DBA only database on each instance. Today he asks you if you have one and if not, why not. There are good reasons to have one, and security is usually not a problem.  Read more...
By Steve Jones 2012/07/31 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 407 reads

Comparing Two Recordsets Using Powershell

How can you quickly and easily compare recordsets from different instances? This article will show you a quick way to do this with PowerShell.  Read more...
By Tom Powell 2012/07/13 | Source: | Category: powershell
Rating: |  Discuss |   Briefcase | 2,021 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: | Category: indexing
Rating: |  Discuss |   Briefcase | 18,768 reads

Instant File Initialization and restores

Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.  Read more...
By Johan Bijnens 2012/05/21 | Source: | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 4,056 reads

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...
By Additional Articles 2012/05/21 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 3,535 reads

Snapshot Isolation Level in SQL Server - What, Why and How - Part 1

Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.  Read more...
By Additional Articles 2012/05/14 | Source: Database Journal | Category: administration
Rating:  Rate this |   Briefcase | 3,551 reads

The Real World: Fragmented Disk and High PAGEIOLATCH Waits

This article decribes how defragementing a 900 GB drive assisted in addressing major performance issues on a reporting server.  Read more...
By Kenneth Igiri 2012/04/20 | Source: | Category: fragmentation
Rating: |  Discuss |   Briefcase | 6,262 reads

Understanding Retention Periods for SQL Server Transactional Replication

I have transactional replication configured in production. I have heard about the replication retention period, but what is the significance of this. Would there be any impact to my replication configuration if data is not synchronized with the subscriptions within the retention period?  Read more...
By Additional Articles 2012/04/17 | Source: | Category: replication
Rating:  Rate this |   Briefcase | 2,368 reads

The Best Database Administrators Automate Everything

Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once it's gone, that's it, gone forever.  Read more...
By John Sansom 2012/04/06 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 10,579 reads

SQL Server Instant File Initialization (PQW)

In this article we’re going to look at instant file initialization. What it is, why it’s cool and how you can use it in your environments.  Read more...
By John Sansom 2012/04/02 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 4,856 reads

How to Document and Configure SQL Server Instance Settings

There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.  Read more...
By Additional Articles 2012/02/13 | Source: SimpleTalk | Category: configuration
Rating:  Rate this |   Briefcase | 3,506 reads

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.  Read more...
By Eric Russell 2012/02/09 | Source: | Category: security
Rating: |  Discuss |   Briefcase | 5,514 reads
<< Newer    Items 41 to 60 of 801    Older >>