Report created on 11/01/2010 15:07:01 by SQL Server Surveyor v1.3.6.15
Copyright © 2008-2010 VirtualObjectives, John Buoro www.VirtualObjectives.com.au

SQLTEST

General Information:

Version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Attributes:

Instance Name: Default Instance
Edition: Standard Edition
Engine Edition: Standard
Product Version: 8.00.2039
Product Level: SP4

Mixed mode authentication.
Not Clustered.
Full-text is installed.

License Type: Licensing is disabled.
Number of Licenses:

Microsoft Version Information (xp_msver):

Index Name Internal Value Character Value
1 ProductName Microsoft SQL Server
2 ProductVersion 524288 8.00.2039
3 Language 1033 English (United States)
4 Platform NT INTEL X86
5 Comments NT INTEL X86
6 CompanyName Microsoft Corporation
7 FileDescription SQL Server Windows NT
8 FileVersion 2000.080.2039.00
9 InternalName SQLSERVR
10 LegalCopyright © 1988-2004 Microsoft Corp. All rights reserved.
11 LegalTrademarks Microsoft® is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename SQLSERVR.EXE
13 PrivateBuild
14 SpecialBuild 133627904
15 WindowsVersion 143851525 5.0 (2195)
16 ProcessorCount 4 4
17 ProcessorActiveMask 15 0000000f
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 2048 2048 (2146975744)
20 Product ID

SQL Server Started:

Started: 02/01/2010 11:06:05
Up-Time: 9 days

SQL Server Service Name:

MSSQLSERVER

IP Network Configuration:

Windows 2000 IP Configuration

	Host Name . . . . . . . . . . . . : SQLTEST
	Primary DNS Suffix  . . . . . . . : Test.net.local
	Node Type . . . . . . . . . . . . : Broadcast
	IP Routing Enabled. . . . . . . . : No
	WINS Proxy Enabled. . . . . . . . : No
	DNS Suffix Search List. . . . . . : Test.net.local
	                                    net.local

Ethernet adapter Local Area Connection:

	Connection-specific DNS Suffix  . : Test.net.local
	Description . . . . . . . . . . . : HP NC7781 Gigabit Server Adapter
	Physical Address. . . . . . . . . : 00-0E-7F-AE-3A-62
	DHCP Enabled. . . . . . . . . . . : No
	IP Address. . . . . . . . . . . . : 10.11.97.13
	Subnet Mask . . . . . . . . . . . : 255.255.255.0
	Default Gateway . . . . . . . . . : 10.11.97.1
	DNS Servers . . . . . . . . . . . : 10.11.97.11

Disk Information:

Drive Total(Mb) Free(Mb) Free(%)
C 10001 7 0
E 90080 24033 26
J 70062 63727 90

SQL Server Statistics (Since SQL Server started):

Login Activity:

15,451 logins or attempted logins.

Work:

3,231 seconds that the server computer's CPU has been doing SQL Server work.
1,390,814 seconds that SQL Server has been idle.
1,456 seconds that SQL Server has spent doing input and output operations.

Disk Activity:

34,349 disk reads (non cache).
222,558 disk writes.
0 disk read/write errors.

Network Activity:

1,044,861 network packets received by SQL Server.
1,466,224 network packets sent by SQL Server.
0 network packet errors encountered whilst sending/receiving.

Scheduled Windows Jobs:

There are no entries in the list.

SQL Server Information:

Server Information (sp_server_info):

Attribute Id Attribute Name Attribute Value
1 DBMS_NAME Microsoft SQL Server
2 DBMS_VER Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
10 OWNER_TERM owner
11 TABLE_TERM table
12 MAX_OWNER_NAME_LENGTH 128
13 TABLE_LENGTH 128
14 MAX_QUAL_LENGTH 128
15 COLUMN_LENGTH 128
16 IDENTIFIER_CASE MIXED
17 TX_ISOLATION 2
18 COLLATION_SEQ charset=iso_1 sort_order=nocase_iso charset_num=1 sort_order_num=52
19 SAVEPOINT_SUPPORT Y
20 MULTI_RESULT_SETS Y
22 ACCESSIBLE_TABLES Y
100 USERID_LENGTH 128
101 QUALIFIER_TERM database
102 NAMED_TRANSACTIONS Y
103 SPROC_AS_LANGUAGE Y
104 ACCESSIBLE_SPROC Y
105 MAX_INDEX_COLS 16
106 RENAME_TABLE Y
107 RENAME_COLUMN Y
108 DROP_COLUMN Y
109 INCREASE_COLUMN_LENGTH Y
110 DDL_IN_TRANSACTION Y
111 DESCENDING_INDEXES Y
112 SP_RENAME Y
113 REMOTE_SPROC Y
500 SYS_SPROC_VERSION 8.00.2020

Global Configuration Settings (sp_configure):

Name Minimum Maximum Config Value Run Value
affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 0 0
nested triggers 0 1 0 0
network packet size (B) 512 32767 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
scan for startup procs 0 1 1 1
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0

Sort Order and Character Set (sp_helpsort):

Collation: SQL_Latin1_General_CP1_CI_AS

Server Default Collation
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

Linked Servers:

Name Network Name Status Id Collation Name Connect Timeout Query Timeout
ERPDEV data access,use remote collation 3 0 0
ERPTST data access,use remote collation 1 0 0
LMSRPTDBTEST LMSRPTDBTEST rpc,rpc out,data access 7 0 0
ORACLE_ERP_HR data access,use remote collation 4 0 0
repl_distributor SQLTEST rpc,dist,rpc out,system,use remote collation 11 0 0
SQLTEST SQLTEST rpc,rpc out,use remote collation 0 0 0

Linked Server Logins:

Linked Server Local Login Is Self Mapping Remote Login
ERPDEV 0 tchrcas
ERPTST 0 tchrcas
LMSRPTDBTEST 0 sa
ORACLE_ERP_HR 0 TCHRCAS
repl_distributor 0 distributor_admin
SQLTEST 1

Target Servers:

sp_Help_TargetServer: None.
sp_Help_TargetServerGroup: None.

Operators:

Id Enabled Email Address Last Email Date Last Email Time Pager Address Last Pager Date Last Pager Time Netsend Address Last Netsend Date Last Netsend Time
1 1 dbadmin@virtualobjectives.com.au 23/04/2009 11:30:23 00/00/0000 00:00:00 00/00/0000 00:00:00

Alerts:

Id Name Enabled Database Name Event Source Message Id Severity Event Description Keyword Delay Between Responses Notification Message Occurrence Count Last Occurrence Date Last Occurrence Time Count Reset Date Count Reset Time Job Name Has Notification Flags Performance Condition
1 Demo: Full msdb log 1 msdb MSSQLSERVER 9002 0 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0
2 Demo: Full tempdb 1 tempdb MSSQLSERVER 9002 0 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0
14 Replication: agent custom shutdown 0 MSSQLSERVER 20578 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
11 Replication: agent failure 0 MSSQLSERVER 14151 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
12 Replication: agent retry 0 MSSQLSERVER 14152 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
13 Replication: agent success 0 MSSQLSERVER 14150 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
19 Replication: expired subscription dropped 0 MSSQLSERVER 14157 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
15 Replication: Subscriber has failed data validation 0 MSSQLSERVER 20574 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
16 Replication: Subscriber has passed data validation 0 MSSQLSERVER 20575 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
17 Replication: Subscription reinitialized after validation failure 0 MSSQLSERVER 20572 0 0 0 00/00/0000 00:00:00 00/00/0000 00:00:00 0 0
3 Demo: Sev. 19 Errors 1 MSSQLSERVER 0 19 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0
4 Demo: Sev. 20 Errors 1 MSSQLSERVER 0 20 10 4 05/07/2006 10:50:23 00/00/0000 00:00:00 1 0
5 Demo: Sev. 21 Errors 1 MSSQLSERVER 0 21 10 6 03/05/2005 12:55:51 00/00/0000 00:00:00 1 0
6 Demo: Sev. 22 Errors 1 MSSQLSERVER 0 22 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0
7 Demo: Sev. 23 Errors 1 MSSQLSERVER 0 23 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0
8 Demo: Sev. 24 Errors 1 MSSQLSERVER 0 24 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0
9 Demo: Sev. 25 Errors 1 MSSQLSERVER 0 25 10 0 00/00/0000 00:00:00 00/00/0000 00:00:00 1 0

SQL Jobs:

SQL Jobs:

Name Description Enabled Originating Server Start Step Id Category Owner Notify Level Eventlog Notify Level Email Notify Level Netsend Notify Level Page Notify Email Operator Notify Netsend Operator Notify Page Operator Delete Level Date Created Date Modified Version Number Last Run Date Last Run Time Last Run Outcome Next Run Date Next Run Time Next Run Schedule Id Current Execution Status Current Execution Step Current Retry Attempt Has Step Has Schedule Has Target Type
CID Backup (BRTC GCJC TSVL MasterCID CIDResource) No description available. 0 sqltest 1 [Uncategorized (Local)] sa 0 0 0 0 (unknown) (unknown) (unknown) 0 20/03/2007 13:06:25 21/10/2008 13:35:09 20 20/10/2008 19:00:01 1 20/07/2009 19:00:00 81 4 0 (unknown) 0 5 1 1 1
CID Employee Import - BRTCCID No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 27/11/2006 15:13:09 29/05/2008 12:49:46 7 24/07/2009 06:00:02 1 25/07/2009 06:00:00 70 4 0 (unknown) 0 1 1 1 1
CID Employee Import - GCJCCID No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 27/11/2006 15:21:21 29/05/2008 12:49:55 8 24/07/2009 06:00:03 1 25/07/2009 06:00:00 73 4 0 (unknown) 0 1 1 1 1
CID Employee Import - TSVLCID No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 27/11/2006 15:21:47 29/05/2008 12:50:03 8 24/07/2009 06:00:04 1 25/07/2009 06:00:00 74 4 0 (unknown) 0 1 1 1 1
Cycle Server Errorlogs Archive current errorlog and start new errorlog. Created as errorlogs were growing to large in production and only being restarted by default on system reboot 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 24/01/2005 14:30:55 05/10/2007 15:30:56 6 13/07/2009 00:00:00 1 27/07/2009 00:00:00 33 4 0 (unknown) 0 1 1 1 1
master backup No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 09/02/2006 15:50:24 09/02/2006 15:50:24 3 24/07/2009 04:00:01 1 25/07/2009 04:00:00 56 4 0 (unknown) 0 1 1 1 1
msdb backup No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 09/02/2006 15:52:04 09/02/2006 15:52:04 3 24/07/2009 04:05:01 1 25/07/2009 04:05:00 57 4 0 (unknown) 0 1 1 1 1
OracleERP - CID Execute package: OracleERP - CID 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 27/11/2006 15:16:19 16/07/2007 09:35:08 8 24/07/2009 05:50:01 1 25/07/2009 05:50:00 72 4 0 (unknown) 0 1 1 1 1
OracleERP - LMS Execute package: OracleERP - LMS 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 13/12/2006 15:17:04 16/07/2007 09:35:40 30 24/07/2009 02:00:01 1 25/07/2009 02:00:00 76 4 0 (unknown) 0 5 1 1 1
OracleERP Backup No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 14/03/2007 12:22:37 14/03/2007 12:22:37 3 24/07/2009 13:00:02 1 25/07/2009 13:00:00 80 4 0 (unknown) 0 1 1 1 1
OracleERP Daily Load No description available. 1 sqltest 1 [Uncategorized (Local)] sa 2 0 0 0 (unknown) (unknown) (unknown) 0 09/05/2007 13:54:34 30/04/2009 09:29:39 26 12/07/2009 21:00:01 1 26/07/2009 21:00:00 84 4 0 (unknown) 0 11 1 1 1
System Databases -Integrity Checks No description available. 1 sqltest 1 Database Maintenance sa 2 0 0 0 (unknown) (unknown) (unknown) 0 08/12/2004 15:49:28 08/12/2004 16:06:36 7 12/07/2009 22:10:01 1 26/07/2009 22:10:00 17 4 0 (unknown) 0 1 1 1 1
System Databases -Reindex No description available. 0 sqltest 1 Database Maintenance sa 2 0 0 0 (unknown) (unknown) (unknown) 0 08/12/2004 15:47:55 13/11/2007 10:25:28 9 11/11/2007 19:30:00 1 26/07/2009 19:30:00 16 4 0 (unknown) 0 1 1 1 1
User Databases - Integrity Checks No description available. 1 sqltest 1 Database Maintenance sa 2 0 0 0 (unknown) (unknown) (unknown) 0 08/12/2004 15:53:42 08/12/2004 16:08:43 7 12/07/2009 22:10:00 1 26/07/2009 22:10:00 19 4 0 (unknown) 0 1 1 1 1
User databases - Reindex No description available. 1 sqltest 1 Database Maintenance sa 2 0 0 0 (unknown) (unknown) (unknown) 0 08/12/2004 15:52:06 27/09/2006 09:31:38 7 12/07/2009 18:30:01 1 26/07/2009 18:30:00 18 4 0 (unknown) 0 1 1 1 1
Reinitialize subscriptions having data validation failures Reinitializes all subscriptions that have data validation failures. 1 sqltest 1 REPL-Alert Response sa 0 0 0 0 (unknown) (unknown) (unknown) 0 29/02/2008 14:05:05 29/02/2008 14:05:05 2 29/02/2008 14:42:44 1 00/00/0000 00:00:00 0 4 0 (unknown) 0 1 0 1 1
Replication agents checkup Detects replication agents that are not logging history actively. 1 sqltest 1 REPL-Checkup sa 2 0 0 0 (unknown) (unknown) (unknown) 0 29/02/2008 14:05:05 29/02/2008 14:05:05 3 24/07/2009 15:00:00 1 24/07/2009 15:10:00 95 4 0 (unknown) 0 1 1 1 1
Distribution clean up: distribution Removes replicated transactions from the distribution database. 1 sqltest 1 REPL-Distribution Cleanup sa 0 0 0 0 (unknown) (unknown) (unknown) 0 29/02/2008 14:05:08 20/03/2008 11:11:49 6 24/07/2009 15:05:00 1 24/07/2009 15:15:00 97 4 0 (unknown) 0 1 1 1 1
Agent history clean up: distribution Removes replication agent history from the distribution database. 1 sqltest 1 REPL-History Cleanup sa 0 0 0 0 (unknown) (unknown) (unknown) 0 29/02/2008 14:05:08 03/03/2008 12:49:16 4 24/07/2009 15:00:01 1 24/07/2009 15:10:00 96 4 0 (unknown) 0 1 1 1 1
SQLTEST-AMPRO-1 No description available. 1 sqltest 1 REPL-LogReader sa 0 0 0 0 (unknown) (unknown) (unknown) 0 20/03/2008 11:11:46 21/04/2008 12:47:27 6 20/07/2009 08:51:34 3 00/00/0000 00:00:00 0 1 2 (Run agent.) 0 3 1 1 1
SQLTEST-AMPRO-AMPRO-3 No description available. 1 sqltest 1 REPL-Snapshot sa 0 0 0 0 (unknown) (unknown) (unknown) 0 20/03/2008 11:11:50 21/04/2008 12:47:32 6 20/03/2008 22:58:00 1 00/00/0000 00:00:00 0 4 0 (unknown) 0 3 1 1 1
Expired subscription clean up Detects and removes expired subscriptions from published databases. 1 sqltest 1 REPL-Subscription Cleanup sa 0 0 0 0 (unknown) (unknown) (unknown) 0 03/03/2008 13:02:42 03/03/2008 13:02:42 3 24/07/2009 01:00:02 1 25/07/2009 01:00:00 101 4 0 (unknown) 0 1 1 1 1

Maintenance Plans:

Plan Name Database Name Date Created Owner Max History Rows Remote History Server Max Remote History Rows Job Name
All ad-hoc plans 06/08/2000 01:33:43 sa 0 0
Reindex System databases All System Databases 08/12/2004 15:47:55 sa 1000 0 System Databases -Reindex
System Databases Integrity Checks All System Databases 08/12/2004 15:49:28 sa 1000 0 System Databases -Integrity Checks
User Databases - Integrity Checks All User Databases 08/12/2004 15:53:42 sa 1000 0 User Databases - Integrity Checks
User databases - Reindex All User Databases 08/12/2004 15:52:06 sa 1000 0 User databases - Reindex

Job History (Last 100):

Job Name Run Status Run Date Run Time Run Duration
(H:M:S)		 Operator Emailed Operator Netsent Operator Paged Retries Attempted Server
Distribution clean up: distribution 1 24/07/2009 15:05:00 0:00:00 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 15:05:00 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 15:00:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 15:00:01 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 15:00:00 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 15:00:00 0:00:00 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:55:00 0:00:01 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:55:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:50:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:50:01 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:50:00 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:50:00 0:00:00 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:45:00 0:00:00 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:45:00 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:40:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:40:01 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:40:00 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:40:00 0:00:00 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:35:00 0:00:01 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:35:00 0:00:01 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:30:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:30:01 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:30:00 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:30:00 0:00:00 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:25:00 0:00:01 0 SQLTEST
Distribution clean up: distribution 1 24/07/2009 14:25:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:20:01 0:00:00 0 SQLTEST
Agent history clean up: distribution 1 24/07/2009 14:20:01 0:00:00 0 SQLTEST
Replication agents checkup 1 24/07/2009 14:20:00 0:00:00 0 SQLTEST

Job Failures (Last 20):

Job Name Run Status Run Date Run Time Run Duration
(H:M:S)		 Operator Emailed Operator Netsent Operator Paged Retries Attempted Server
OracleERP - LMS 0 24/07/2009 02:00:37 0:00:01 0 SQLTEST
OracleERP - LMS 0 23/07/2009 02:00:30 0:00:00 0 SQLTEST
OracleERP - LMS 0 22/07/2009 02:00:26 0:00:00 0 SQLTEST
OracleERP - LMS 0 21/07/2009 02:00:27 0:00:00 0 SQLTEST
OracleERP - LMS 0 18/07/2009 02:00:29 0:00:00 0 SQLTEST
OracleERP - LMS 0 17/07/2009 02:00:28 0:00:00 0 SQLTEST
OracleERP - LMS 0 16/07/2009 02:00:27 0:00:00 0 SQLTEST
OracleERP - LMS 0 15/07/2009 02:00:28 0:00:00 0 SQLTEST
OracleERP - LMS 0 14/07/2009 02:00:27 0:00:01 0 SQLTEST
OracleERP - LMS 0 13/07/2009 02:00:33 0:00:00 0 SQLTEST
OracleERP - LMS 0 12/07/2009 02:00:29 0:00:00 0 SQLTEST
OracleERP - LMS 0 11/07/2009 02:00:28 0:00:00 0 SQLTEST
OracleERP - LMS 0 10/07/2009 02:00:27 0:00:00 0 SQLTEST
OracleERP - LMS 0 09/07/2009 02:00:27 0:00:00 0 SQLTEST
OracleERP - LMS 0 08/07/2009 02:00:28 0:00:00 0 SQLTEST
OracleERP - LMS 0 07/07/2009 02:00:26 0:00:00 0 SQLTEST

Long Running Jobs (Last 20):

Job Name Run Status Run Date Run Time Run Duration
(H:M:S)		 Operator Emailed Operator Netsent Operator Paged Retries Attempted Server
WFMS Daily Load 1 06/07/2009 18:00:02 4:42:59 0 SQLTEST
WFMS Daily Load 1 06/07/2009 18:00:02 4:42:59 0 SQLTEST
WFMS Daily Load 1 07/07/2009 18:00:02 4:31:58 0 SQLTEST
WFMS Daily Load 1 07/07/2009 18:00:02 4:31:58 0 SQLTEST
WFMS Daily Load 1 01/07/2009 18:00:02 4:19:14 0 SQLTEST
WFMS Daily Load 1 01/07/2009 18:00:02 4:19:14 0 SQLTEST
WFMS Daily Load 1 09/07/2009 18:00:02 4:18:23 0 SQLTEST
WFMS Daily Load 1 09/07/2009 18:00:02 4:18:23 0 SQLTEST
WFMS Daily Load 1 02/07/2009 18:00:02 4:14:59 0 SQLTEST
WFMS Daily Load 1 02/07/2009 18:00:02 4:14:59 0 SQLTEST
WFMS Daily Load 1 27/06/2009 18:00:02 4:05:55 0 SQLTEST
WFMS Daily Load 1 27/06/2009 18:00:02 4:05:55 0 SQLTEST
WFMS Daily Load 1 29/06/2009 18:00:02 3:49:53 0 SQLTEST
WFMS Daily Load 1 29/06/2009 18:00:02 3:49:53 0 SQLTEST
WFMS Daily Load 1 30/06/2009 18:00:02 3:49:46 0 SQLTEST
WFMS Daily Load 1 30/06/2009 18:00:02 3:49:46 0 SQLTEST
WFMS Daily Load 1 25/06/2009 18:00:02 3:46:34 0 SQLTEST
WFMS Daily Load 1 25/06/2009 18:00:02 3:46:34 0 SQLTEST
WFMS Daily Load 1 11/07/2009 18:00:02 3:45:03 0 SQLTEST
WFMS Daily Load 1 11/07/2009 18:00:02 3:45:03 0 SQLTEST

Database Devices:

Device Name Physical Name Description Status Cntrltype Size
master C:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf special, physical disk, 4 MB 2 0 512
mastlog C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf special, physical disk, 1 MB 2 0 128
modeldev C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf special, physical disk, 0.6 MB 2 0 80
modellog C:\Program Files\Microsoft SQL Server\MSSQL\data\modellog.ldf special, physical disk, 0.8 MB 2 0 96
tempdev C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf special, physical disk, 2 MB 2 0 256
templog C:\Program Files\Microsoft SQL Server\MSSQL\data\templog.ldf special, physical disk, 0.5 MB 2 0 64

Databases:

Name Db Size Owner Dbid Created Status Compatibility Level
AMPRO 145.38 MB sa 14 Jan 22 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsPublished 80
BRTCCID 289.44 MB sa 39 Jul 6 2006 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
CIDResource 854.75 MB sa 15 Aug 8 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
distribution 4.75 MB sa 19 Feb 29 2008 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
eBetInterface 375.56 MB sa 7 Aug 31 2007 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
GCJCCID 226.31 MB sa 10 Nov 27 2006 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
master 18.25 MB sa 1 Aug 6 2000 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
MasterCID 20.00 MB sa 29 Jul 2 2007 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
model 1.13 MB sa 3 Aug 6 2000 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
msdb 207.88 MB sa 4 Aug 6 2000 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
Northwind 4.63 MB sa 16 Mar 30 2009 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
OracleERP 159.00 MB sa 6 Sep 29 2006 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
tempdb 604.00 MB sa 2 Jul 20 2009 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsAutoCreateStatistics, IsAutoUpdateStatistics 80
TSVLCID 65.31 MB sa 28 Nov 27 2006 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=SQL_Latin1_General_CP1_CI_AS, SQLSortOrder=52, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics 80

Name Fileid Filename Filegroup Size Maxsize Growth Usage
AMPRO_dat 1 E:\MSSQL\Data\AMPRO.mdf PRIMARY 140672 KB Unlimited 10% data only
AMPRO_log 2 E:\MSSQL\Data\AMPRO_log.ldf 8192 KB Unlimited 20480 KB log only
Database Name Database Size Unallocated Space
AMPRO 145.38 MB 90.80 MB
Reserved Data Index Size Unused
47688 KB 47272 KB 36960 KB -36544 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
CIDResource_Data 1 e:\MSSQL\Data\CIDResource_Data.MDF PRIMARY 853760 KB Unlimited 10240 KB data only
CIDResource_Log 2 e:\MSSQL\Data\CIDResource_Log.LDF 21504 KB Unlimited 20480 KB log only
Database Name Database Size Unallocated Space
CIDResource 854.75 MB 329.07 MB
Reserved Data Index Size Unused
516792 KB 515344 KB 1288 KB 160 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
distmodel 1 E:\MSSQL\Data\distribution.MDF PRIMARY 3840 KB Unlimited 10% data only
distmodel_log 2 E:\MSSQL\Data\distribution.LDF 1024 KB Unlimited 10% log only
Database Name Database Size Unallocated Space
distribution 4.75 MB 0.74 MB
Reserved Data Index Size Unused
3080 KB 1792 KB 968 KB 320 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
SCSIMS_Data 1 e:\MSSQL\Data\GCJCCID_Data.mdf PRIMARY 220480 KB Unlimited 5120 KB data only
SCSIMS_Log 2 e:\MSSQL\Data\GCJCCID_log.ldf 11264 KB Unlimited 10240 KB log only
Database Name Database Size Unallocated Space
GCJCCID 226.31 MB 41.48 MB
Reserved Data Index Size Unused
178000 KB 160784 KB 2544 KB 14672 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
master 1 C:\Program Files\Microsoft SQL Server\MSSQL\data\master.mdf PRIMARY 17920 KB Unlimited 10% data only
mastlog 2 C:\Program Files\Microsoft SQL Server\MSSQL\data\mastlog.ldf 768 KB Unlimited 10% log only
Database Name Database Size Unallocated Space
master 18.25 MB 1.63 MB
Reserved Data Index Size Unused
16248 KB 12152 KB 1448 KB 2648 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
MasterCID_Data 1 E:\MSSQL\Data\MasterCID_Data.MDF PRIMARY 10240 KB Unlimited 5120 KB data only
MasterCID_Log 2 E:\MSSQL\Data\MasterCID_Log.LDF 10240 KB Unlimited 10240 KB log only
Database Name Database Size Unallocated Space
MasterCID 20.00 MB 8.20 MB
Reserved Data Index Size Unused
1840 KB 1576 KB 984 KB -720 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
modeldev 1 C:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf PRIMARY 640 KB Unlimited 10% data only
modellog 2 C:\Program Files\Microsoft SQL Server\MSSQL\data\modellog.ldf 512 KB Unlimited 10% log only
Database Name Database Size Unallocated Space
model 1.13 MB 0.11 MB
Reserved Data Index Size Unused
528 KB 144 KB 280 KB 104 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
MSDBData 1 C:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf PRIMARY 206976 KB Unlimited 256 KB data only
MSDBLog 2 C:\Program Files\Microsoft SQL Server\MSSQL\data\msdblog.ldf 5888 KB Unlimited 256 KB log only
Database Name Database Size Unallocated Space
msdb 207.88 MB 97.27 MB
Reserved Data Index Size Unused
107368 KB 23656 KB 4248 KB 79464 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
Northwind 1 E:\MSSQL\Data\northwnd.mdf PRIMARY 3712 KB Unlimited 10% data only
Northwind_log 2 E:\MSSQL\Data\northwnd.ldf 1024 KB Unlimited 10% log only
Database Name Database Size Unallocated Space
Northwind 4.63 MB 0.87 MB
Reserved Data Index Size Unused
2824 KB 1112 KB 1304 KB 408 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
OracleHR_Data 1 E:\MSSQL\Data\OracleERP.mdf PRIMARY 156672 KB Unlimited 10240 KB data only
OracleHR_Log 2 E:\MSSQL\Data\OracleERP_log.ldf 6144 KB Unlimited 5120 KB log only
Database Name Database Size Unallocated Space
OracleERP 159.00 MB 1.41 MB
Reserved Data Index Size Unused
155232 KB 151728 KB 1048 KB 2456 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
tempdev 1 C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf PRIMARY 566784 KB 3072000 KB 51200 KB data only
templog 2 C:\Program Files\Microsoft SQL Server\MSSQL\data\templog.ldf 51712 KB 3072000 KB 51200 KB log only
Database Name Database Size Unallocated Space
tempdb 604.00 MB 552.73 MB
Reserved Data Index Size Unused
784 KB 248 KB 400 KB 136 KB
Name Fileid Filename Filegroup Size Maxsize Growth Usage
SCSIMS_Data 1 e:\MSSQL\Data\TSVLCID_Data.mdf PRIMARY 55616 KB Unlimited 5120 KB data only
SCSIMS_Log 2 e:\MSSQL\Data\TSVLCID_log.ldf 11264 KB Unlimited 10240 KB log only
Database Name Database Size Unallocated Space
TSVLCID 65.31 MB 18.16 MB
Reserved Data Index Size Unused
37024 KB 32688 KB 2408 KB 1928 KB

Fixed Database Roles:

Serverrole Description
sysadmin System Administrators
securityadmin Security Administrators
serveradmin Server Administrators
setupadmin Setup Administrators
processadmin Process Administrators
diskadmin Disk Administrators
dbcreator Database Creators
bulkadmin Bulk Insert Administrators

Serverrole Membername
sysadmin BUILTIN\Administrators
sysadmin distributor_admin
sysadmin sa
sysadmin TEST\DBA
sysadmin TEST\SQLService

Logins and Access Levels:

Loginname Defdbname Deflangname Auser Aremote
AmproUser master us_english yes no
BUILTIN\Administrators master us_english NO no
distributor_admin master us_english NO YES
reportdev master us_english NO no
sa master us_english yes no
TEST\DBA master us_english NO no
TEST\ebet master us_english yes no
TEST\SQLService master us_english NO no

Loginname Dbname Username Useroralias
AmproUser AMPRO AmproUser User
AmproUser AMPRO db_owner MemberOf
sa AMPRO db_owner MemberOf
sa AMPRO dbo User
sa BRTCCID db_owner MemberOf
sa BRTCCID dbo User
sa CIDResource db_owner MemberOf
sa CIDResource dbo User
sa distribution db_owner MemberOf
sa distribution dbo User
sa GCJCCID db_owner MemberOf
sa GCJCCID dbo User
sa master db_owner MemberOf
sa master dbo User
sa model db_owner MemberOf
sa model dbo User
sa msdb db_owner MemberOf
sa msdb dbo User
sa Northwind db_owner MemberOf
sa Northwind dbo User
sa OracleERP db_owner MemberOf
sa OracleERP dbo User
sa tempdb db_owner MemberOf
sa tempdb dbo User
sa TSVLCID db_owner MemberOf
sa TSVLCID dbo User

Windows Account Privileges:

Account Name Type Privilege Mapped Login Name Permission Path
BUILTIN\Administrators group admin BUILTIN\Administrators
TEST\DBA group admin TEST\DBA
TEST\SQLService user admin TEST\SQLService

Orphaned Windows Users or Groups:

None.

Login Security Configuration:

Name Config Value
login mode Mixed
default login guest
default domain TEST
audit level failure
set hostname false
map _ domain separator
map $
map # -

Database Replication:

Databases Replicated:

Name Id Transpublish Mergepublish Dbowner Dbreadonly
AMPRO 1 True False True False
BRTCCID 5 False False True False
CIDResource 6 False False True False
GCJCCID 10 False False True False
MasterCID 13 False False True False
Northwind 14 False False True False
OracleERP 15 False False True False
TSVLCID 18 False False True False

Distributors:

sp_HelpDistributor:
Distributor Distribution Database Directory Account Min Distrib Retention Max Distrib Retention History Retention History Cleanup Agent Distribution Cleanup Agent Rpc Server Name Rpc Login Name
SQLTEST distribution \\SQLTEST\ReplData sqlservice@test.net.local 0 72 72 Agent history clean up: distribution Distribution clean up: distribution repl_distributor distributor_admin

sp_HelpDistributionDB:
Name Min Distretention Max Distretention History Retention History Cleanup Agent Distributor Cleanup Agent Status Data Folder Data File Data File Size Log Folder Log File Log File Size
distribution 0 72 72 Agent history clean up: distribution Distribution clean up: distribution 0 E:\MSSQL\Data distribution.MDF 3 E:\MSSQL\Data distribution.LDF 1

Publishers that serve as their own Distributor:

Name Distribution Db Security Mode Login Password Active Working Directory Trusted Thirdparty Flag
SQLTEST distribution 1 sa ???????????????????????????????????????????? True \\SQLTEST\ReplData False False

Publications:

sp_HelpPublication:
Pubid Name Restricted Status Task Replication Frequency Synchronization Method Description Immediate Sync Enabled For Internet Allow Push Allow Pull Allow Anonymous Independent Agent Immediate Sync Ready Allow Sync Tran Autogen Sync Procs Snapshot Jobid Retention Has Subscription Allow Queued Tran Snapshot In Defaultfolder Alt Snapshot Folder Pre Snapshot Script Post Snapshot Script Compress Snapshot Ftp Address Ftp Port Ftp Subdirectory Ftp Login Allow Dts Allow Subscription Copy Centralized Conflicts Conflict Retention Conflict Policy Queue Type Backward Comp Level Publish To Ad
1 AMPRO 0 1 1 0 0 Transactional publication of AMPRO database from Publisher SQLTEST. False False True True False False False False False (BYTES) 336 0 False True False 21 anonymous False False 14 10 0

sp_HelpMergePublication: None.

Subscriptions:

sp_HelpMergePullSubscription: None.
sp_HelpPullSubscription: None.

Subscribers:

sp_HelpSubscriberInfo:
Publisher Subscriber Type Login Password Commit Batch Size Status Batch Size Flush Frequency Frequency Type Frequency Interval Frequency Relative Interval Frequency Recurrence Factor Frequency Subday Frequency Subday Interval Active Start Time Of Day Active End Time Of Day Active Start Date Active End Date Retryattempt Retrydelay Description Security Mode Frequency Type2 Frequency Interval2 Frequency Relative Interval2 Frequency Recurrence Factor2 Frequency Subday2 Frequency Subday Interval2 Active Start Time Of Day2 Active End Time Of Day2 Active Start Date2 Active End Date2
SQLTEST DWHTEST 0 100 100 1 64 1 2 0 8 1 0 235900 0 99991231 4 4 1 4 1 2 0 8 1 0 235900 0 99991231

sp_HelpSubscription_Properties: None.

Replication Statistics:

Database Replicated Transactions Replication Rate Trans/Sec Replication Latency (Sec) Replbeginlsn Replnextlsn
AMPRO 0 0 0 (BYTES) (BYTES)

Agent Profiles:

Profile Id Profile Name Agent Type Type Description Def Profile
1 Default agent profile 1 0 True
2 Default agent profile 2 0 True
3 Verbose history agent profile. 2 0 Agent profile for detailed history logging. False
4 Default agent profile 3 0 True
5 Verbose history agent profile. 3 0 Agent profile for detailed history logging. False
6 Default agent profile 4 0 True
7 Slow link agent profile. 4 0 Agent profile for low bandwidth connections. False
8 Verbose history agent profile. 4 0 Agent profile for detailed history logging. False
9 Windows Synchronization Manager profile 4 0 Profile used by the Windows Synchronization Manager. False
10 Windows Synchronization Manager profile 3 0 Profile used by the Windows Synchronization Manager. False
11 Default agent profile 9 0 Agent profile for replicated queued transaction reader. True
12 Rowcount validation profile. 4 0 Profile used by the Merge Agent to perform rowcount validation. False
13 Rowcount and checksum validation profile. 4 0 Profile used by the Merge Agent to perform rowcount and checksum validation. False
14 Continue on data consistency errors. 3 0 Agent profile for skipping data consistency errors. It can be used only by SQL Server Subscribers. False
15 High Volume Server-to-Server Profile 4 0 Merge agent profile optimized for the high volume server-to-server synchronization scenario. False


Report created on 11/01/2010 15:07:01 by SQL Server Surveyor v1.3.6.15
Copyright © 2008-2010 VirtualObjectives, John Buoro www.VirtualObjectives.com.au