|
|
 |
Sysprocesses table definition
|
| Total Hit (751) |
The sysprocesses table holds information about processes running on Microsoft® SQL Server™. These processes can be client processes or system processes. sysprocesses is stored only in the master database.
|
Rating
 |
|
|
|
Monitor Event Viewer on Multiple SQL Servers
|
| Total Hit (694) |
Muthusamy Anantha Kumar discusses three methods to monitor SQL Server Event Log on a list of servers and store the output either in a .CSV file or on a database table.
|
| Rating
|
|
|
|
SQL Server and Collation
|
| Total Hit (504) |
Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
....Read More |
| Rating
|
|
|
|
Monitor Disk Space on Multiple SQL Servers
|
| Total Hit (616) |
In the typical IT department, an un-avoidable task is to monitor the disk space on all drives on certain servers. In addition, the methods presented here will help in monitoring the growth of files. In this article, I am going to discuss three different ways to monitor disk space on a list of server
....Read More |
| Rating
|
|
|
|
Control your SQL Server 7.0 and 2000 via E-Mail
|
| Total Hit (905) |
Data Base Administrators are often exposed to a situation where they want to query a table, check on the status of a server, check an error log or run a DBCC command on a SQL Server box when they do not have access to the box directly. This often happens when they are off site or on vacation or they
....Read More |
| Rating
|
|
|
|
Troubleshooting SQL Server Jobs
|
| Total Hit (681) |
If you have problems with SQL Server jobs, review this troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
Configuring Disks and Managing Space in SQL Server Part 1
|
| Total Hit (944) |
Something like fifty percent of system outages are caused by "Out of space" conditions. I kid you not. I run into them all the time. Combine this problem with the need to maintain high availability and peak performance and the consequence is that disk configuration and space allocation become one of
....Read More |
| Rating
|
|
|
|
Troubleshooting SQL Mail
|
| Total Hit (745) |
If you have problems with SQL Mail, review this 20-point troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
|
|
Using xp_fixeddrives to Monitor Free Space
|
| Total Hit (787) |
As a DBA one of your responsibilities is to monitor disk space. You always need to make sure you have enough for your databases, database backups and any other types of files you plan to store on your server. If you don't monitor your disk space and make sure you have enough space, eventually one of
....Read More |
| Rating
|
|
|
|
Troubleshooting SQL Server Alerts
|
| Total Hit (1091) |
If you have problems with Microsoft SQL Server alerts, review this troubleshooting checklist to find potential solutions.
|
| Rating
|
|
|
|
Migrating a Maintenance Plan from One SQL Server to Another
|
| Total Hit (901) |
Have you ever had to migrate all of the SQL Server objects from one machine to another SQL Server box? If you have, you probably have found that Microsoft has not provided a method to build a migration script for a maintenance plan. Since there is no easy way to migrate a maintenance plan, most DBAs
....Read More |
| Rating
|
|
|
|
How to Create ODBC DSN on multiple SQL server machines
|
| Total Hit (2084) |
In a typical Client - Server environment it is often necessary to create ODBC DSN on many client machines or servers for front-end applications such as VB, or MS-Access, which uses ODBC DSN for linked tables. Even for creating linked servers to heterogeneous systems like Oracle, Sybase and mainframe
....Read More |
| Rating
|
|
|
|
Attaching and Detaching Databases on SQL Server
|
| Total Hit (927) |
If you need to move a database, or database file to another server or disk, and you do not want to backup the database, copy the backup on another server, and then re-create the database from the backup, you can use the sp_detach_db and sp_attach_db system stored procedures to detach the database an
....Read More |
| Rating
|
|
|
|
Generate Scripts for SQL Server Objects
|
| Total Hit (2541) |
We all like the Generate Script feature of Enterprise Manager and like to use it programmatically. One of the most important uses would be backing up scripts periodically using SQL Server Scheduler.
|
| Rating
|
|
|
|
Scheduled Task Reporting on SQL Server
|
| Total Hit (619) |
If you have a server with a large number of scheduled tasks, you will know that keeping track of them all can be a bit difficult at times - checking and double-checking that your database backups and log backups are in synch, that maintenance tasks go off in the correct order, and that tasks do not
....Read More |
| Rating
|
|
|
|
A Server by Any Other Name
|
| Total Hit (750) |
It is imperative to change the server name when infrastructure policy changes, naming convention standard changes or making a standby server the production server (when production server fails). When a server name is changed, SQL server should go through a process to acknowledge and assimilate the c
....Read More |
| Rating
|
|
|
|
Streamlining the Database Server Recovery Process on SQL Server
|
| Total Hit (683) |
Are you tired of manually restoring each database on a new server when the original server has a melt down? Does the manual process seem slow, and prone to keystoke and mouse click errors? Would you like to have those restore scripts automatically built, so you only have to fire them off? Well this
....Read More |
| Rating
|
|
|
|
Synchronizing Production Data with a Test Database on SQL Server
|
| Total Hit (711) |
Every corporation has a unique infrastructure environment. Let us consider a simple production, testing, and a development environment. The SQL scripts application, developed in a development environment will be tested in a QA environment and then moved to production on a production date. Usually th
....Read More |
| Rating
|
|
|
|
Nightly Failed Jobs Report
|
| Total Hit (922) |
Do you get tired of reviewing each SQL Agent notification nightly to determine which SQL Agent jobs failed? Are there a significant number of SQL Agent job notifications that it takes a while to review each? Here is an alternative that allows you to have a single email report of all job failures.
....Read More |
| Rating
|
|
|
|
|
|
How to Do SQL Server Log Shipping ?
|
| Total Hit (1559) |
This article is about log shipping, a refined variation of the traditional manual standby failover server process. Its two major benefits over the traditional methods is that it automates most of the manual work and helps to reduce potential data loss even more.
....Read More |
| Rating
|
|
|
|
An Introduction to SQL Server Clustering
|
| Total Hit (533) |
If your mission-critical SQL Server should experience a motherboard failure, how long will it be down? One hour, four hours, a day, or longer? How much will this cost your business in lost sales or productivity? And perhaps even more important to you, what will it do to your stress level?
....Read More |
| Rating
|
|
|
|
How to Install Windows 2000 Cluster Services
|
| Total Hit (546) |
SQL Server clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 7.0 or SQL Server 2000, and time. Lots of it. The purpose of this article is to get you started along your way to SQL Server clustering. As a precursor to this step, you must first install and configu
....Read More |
| Rating
|
|
|
|
Dealing with a SQL Server Cluster Failover
|
| Total Hit (539) |
I had just gotten out of a short meeting and went to my desk to see what important e-mail messages I might had missed. In my inbox was a series of messages sent from ELM Enterprise Manager 3.0, the software we use to monitor our SQL Server event logs. The message had arrived about 30 minutes earlier
....Read More |
| Rating
|
|
|
|
Setting Up Snapshot Replication: A Step-by-step Guide
|
| Total Hit (741) |
In this article, I want to tell you about some general Microsoft SQL Server replication topics: replication topologies, replication types, and replication agents. I will also discuss Snapshot replication: how to check necessary conditions for this type of replication and how to backup and restore th
....Read More |
| Rating
|
|
|
|
Storage Engine Capacity Planning Tips
|
| Total Hit (1750) |
The I/O subsystem (storage engine) is a key component of any relational database management system (RDBMS). A successful RDBMS implementation requires careful planning at the early stages of the project. The storage engine comprises much of this planning, including what hardware to purchase, how to
....Read More |
| Rating
|
|
|
|
Log Shipping
|
| Total Hit (702) |
It is 2 PM on a record business day. The Microsoft® SQL Server™ 2000 server housing your mission-critical customer database experiences a disk failure. What do you do? When was the last known good backup? Is there another server available to restore the backup onto? Is SQL Server even on that server
....Read More |
| Rating
|
|
|
|
Failover Clustering
|
| Total Hit (746) |
Continuous uptime in a production environment, whether it is a database powering a mission-critical client/server application or an e-commerce Web site, is becoming a common businesses requirement. This chapter describes Microsoft® SQL Server™ 2000 failover clustering, one method of creating high av
....Read More |
| Rating
|
|