| Author |
Topic |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2007-09-27 : 14:10:49
|
| I did these testing to find out if the server is ready to be decomissioned.- Disabled user name access to Databases for 1 day and did not receive any complains.- I found out Database sizes haven't been changed 18 daysany other ideas?=============================http://www.sqlserverstudy.com |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-09-27 : 14:13:01
|
| Run a trace for a couple days or longer... |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-27 : 14:56:23
|
| If you are comfortable disabling user name access, why not just turn the server off (or unplug it from network) for a day or more and see if you get any complaints?We have access logging built into our applications / databases, so we would be able to establish whether a database / server was "unused" from that ... might be worth considering for the futureKristen |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
Posted - 2007-09-27 : 17:11:02
|
| if i dont disable the user name. how is it posible to check if there is activity? any ideas?=============================http://www.sqlserverstudy.com |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-27 : 17:14:21
|
| I just stop the SQL Server service and wait for calls. If I don't receive anything in about a month, then I know it's not in use. I know exactly what is in use and what is not in use for production systems, just not other environments as projects come and go.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-09-27 : 17:32:40
|
| You could set the SQL Server Audit Level to All, and see then look at the servers Security log to see if you are getting any connections.CODO ERGO SUM |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-09-27 : 17:54:52
|
| Or you could run a profiler trace... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-27 : 23:45:40
|
| How don't just ask users if they still use db on the server? |
|
|
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-28 : 10:15:13
|
quote:
Originally posted by funketekun
USers dont know.=============================http://www.sqlserverstudy.com
You're speaking THE TRUTH with this!_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
decommission Server