Module 14: Appendix A - Troubleshooting Common Administrative I...
1 of 20
Module Administrative
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Common
Contents:
Lesson 1: Lesson 2: Lesson 3: Lab:
Module Database administrators role of troubleshooter
the important from
working. It is
general, and to be
familiar with
Server systems.
Objectives After completing • Explain the • Resolve service-related • Resolve login
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
2 of 20
Lesson Before starting methodology science. However, You should aim
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Methodology troubleshooting as much as a troubleshooters. successfully
troubleshoot
Lesson After completing • Describe the • Apply a troubleshooting
Discussion:
Troubleshooters
Consider the • What characteristics troubleshooters? • What characteristics
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
3 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Characteristics • Follows a • Stays calm, • Is able to • Knows about • Ensures the
Characteristics • Adopts a haphazard • Becomes • Makes assumptions • Quickly decides
tries to justify
the selection • Assumes problems
Applying
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
4 of 20
A key characteristic logical manner.
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
methodology in a following list
describes four Investigation This is a critical
finding
solutions. However,
in your
understanding One very important affected user’s example, there reason, regardless You need to
from the professional. For use it for any system is working. mistake is to
assume that,
work. Make
sure that there
Also find out
about anything,
changed since
that time. Finally, you
common
troubleshooting
resolve that
problem, and Analysis Phase In the analysis trying to resolve.
that you are causes, no
matter how unlikely A discussion capable of constantly two types of that constantly
person is benefits from and another logically and
laterally.
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
5 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Implementation In the implementation elimination usually
process of in order,
from the most The critical aspect eliminating potential
for of potential
causes and have
analysis phase
and recheck
might even
need to go back Validation Too many people,
problems
are resolved
resolved a
problem, this In the investigation is resolved. In
decide if the issue really is
resolved. Documentation After the problem
the
organization
Lesson In the remainder
issues that
can arise when SQL Server these services considerations
issues with are some involving
problems with
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
6 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Lesson After completing • Troubleshoot • Use the SQL • Use Windows
Troubleshooting
The most common
services will not
start or cannot
services are not
permitted to to the service
are available logged on at
the console to Windows and The most common
account logon is
failing for some
the account
could be locked
system event
log. More complex recommended,
is as the first
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
7 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
step in resolving Other Service-related If SQL Server
network
issues. In rare
connections.
In this and similar Dedicated Administration Occasionally, If SQL Server • Whether or
using the the problem. problem. following: database is
corrupt. If • Whether or recreates the database files ( • Whether or Server from
Server to the accessible. starting SQL service and
make sure
SQL Server
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
8 of 20
The SQL Server view the log However, if you contents of the
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
You can Studio. see the such as
Notepad. The current error
Server keeps
a set of archive
occurring for
some time.
Windows
Windows services
find
information
applications,
over time SQL
application
log. Therefore,
that are logged
but not producing
Demonstration:
Issues
In this demonstration,
Demonstration
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
9 of 20
1.
Ensure log on
2.
On the
3.
In the Connect
4.
On the
5.
In the Open
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
running, and password Pa$$w0rd.
TroubleshootingServices. 6.
Follow
7.
Close SQL
Lesson Connectivity SQL Server
Issues work with making
connections
they may
have issues with
create
logins that are database administrator,
you, as a issues.
Lesson After completing • Troubleshoot • Troubleshoot
Troubleshooting
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
10 of 20
The most common
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
cannot
connect to SQL Eliminate the The first step
are related to
network connectivity.
attempting
to connect via SQL Server via service. Login
cannot access login or the troubleshooting was
discussed in Network-related If the login using rare cases, you
network-related. In client and the
server, but most
Test Can the server
the address of usually involve the server that that you see an
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
11 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Test Can the network
resolved to a possible TCP/IP successfully ping the assuming that it commands area will relate gateway/router addresses.
Is the browser
Server, the
are not using fixed
the names of the is achieved by UDP port disabled, the named fixed ports and the ports, sure that the library, such as
Is the client configured settings?
attempting to use on the server appropriate.
Is a firewall blocking
firewall blocking the a firewall is will likely
Troubleshooting
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
12 of 20
The typical issue SQL Server but
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
connection to perform depend
upon the type • For Windows
Controller to
process them. • For SQL Server Authentication. configured
Server SQL Server is returned in this
situation says
Also, when working and that the login SQL Server
password is correct problem for to SQL
Server does not
applications that
were designed
account policy for
SQL Server For both types,
as well as
being able to
include the
default database
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
13 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
If a login problem
make sure that
there isn't a logon
connecting,
the error message
prevented
the connection.
Lab: Troubleshooting Scenario You need to time they are
services at the attempt to
troubleshoot
Objectives After completing • Troubleshoot • Troubleshoot • Troubleshoot • Troubleshoot • Troubleshoot
Lab Setup Estimated Time: Virtual machine: User name: AdventureWorks\ Password: Pa$$w0rd
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
14 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
Exercise
Scenario Users of the
the server.
The application The main tasks 1.
Read the
2.
Troubleshoot
Task 1: Read
• Read the scenario
Task 2: Troubleshoot
1.
Troubleshoot
2.
Resolve
3.
If you have
Result: After
issue.
Exercise
Scenario A junior DBA development
to the can no longer
connect to it.
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
15 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
The main tasks 1.
Read the
2.
Troubleshoot
Task 1: Read
• Read the supporting
Task 2: Troubleshoot
1.
Troubleshoot
2.
Resolve
3.
If you have
Result: After
Exercise
issue.
Issue
Scenario Users are complaining
execute.
The main tasks 1.
Read the
2.
Troubleshoot
Task 1: Read
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
16 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
• Read the exercise
Task 2: Troubleshoot
1.
Troubleshoot
2.
Resolve
3.
If you have
Result: After
execution issue.
Exercise
Scenario The performance
database was
deployed. Queries The main tasks 1.
Read the
2.
Troubleshoot
Task 1: Read
• Read the exercise
Task 2: Troubleshoot
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
17 of 20
1.
Troubleshoot
2.
Resolve
3.
If you have
Result: After
Exercise
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
performance issue.
Issue
Scenario A strange situation more users are single user connects
work slower as when only a long and
sometimes it The main tasks 1.
Read the
2.
Troubleshoot
Task 1: Read
• Read the exercise
Task 2: Troubleshoot
1.
Troubleshoot
2.
Resolve
3.
If you have
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
18 of 20
Result: After
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
connection issue.
Review Review Question(
Module Best Practice: 1. Monitor for 2.
Clearly
3.
Apply
for example,
Review Question(
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
19 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
26/09/2016 15:57
Module 14: Appendix A - Troubleshooting Common Administrative I...
20 of 20
https://skillpipe.courseware-marketplace.com/reader/fr-FR/Book/Book...
26/09/2016 15:57