Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 A few WIDELY assorted questions!!

Author  Topic 

jaybee
Yak Posting Veteran

72 Posts

Posted - 2008-10-15 : 15:47:25
Hi all, been meaning to ask these questions for a long time but never had the time for a bunch of threads, so I thought I'd centralise. Sorry if any belong in another section:

1) Change Management - what size of change means completing a request form?

2) Backups - Would you recommend 3rd party software instead of native, and how do you minimise the time on VLDB's and the strain on the LAN?

3) Moving to another box - how do you migrate users?

4) Monitoring software - what do you use, and what jobs/perf counters do you monitor for?

5) Maintenance plans - what do you have in place, and what extra for VLDB?



Thanks in advance all,



Jaybee.



tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-15 : 15:59:05
1. That's a question for your organization.
2. I recommend only SQL Server backups. It can be native or 3rd party such as SQL Litespeed. We use LS for all of our production databases to save money on disks.
3. I use and wrote this: http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx. I also use item 4 in that blog.
4. MOM, Performance Monitor, SQL Profiler, custom VB.NET app
5. None, I use only custom scripts. See this: http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx and this: http://weblogs.sqlteam.com/tarad/archive/2008/06/30/SQL-Server-jobs-on-production-instances.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jaybee
Yak Posting Veteran

72 Posts

Posted - 2008-10-16 : 13:49:00
Cheers Tara, appreciate the tips.

In terms of CM...as far as I'm concerned, something as trivial as flushing the log of course doesn't matter, but the line I draw just after, say, dropping a login by request of HR. As long as I get a mail from them I'll do it, but I want the docu retrospectively. Anything more serious - say dropping a user DB - I'll want the docu in advance.

Couple of questions...

2) You mentioned you saved money with LS, I presume it compresses the data and decompresses at the target? What kind of ratios do you get?

4) MOM ??
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-17 : 00:08:10
Litespeed and other 3rd party backup software such as Red Gate's compresses the file as it is backing up. You not only save on disks, but also on the backup time and therefore resources in terms of performance.

We see about 75% savings in disk space and backup time.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -