configuration for server

• SeeCoolGuy

  SSCrazy

  Points: 2902

  More actions

  February 15, 2005 at 5:32 pm

  #86727

  I ran a basic showadvance (sp_configure) to gain the global settings for my sql server, but I thought there was also a script somewhere that would allow me to see the # of processors and size of all db's

  -- Francisco

• Johan Bijnens

  SSC Guru

  Points: 135265

  More actions

  February 16, 2005 at 12:31 am

  #542459

  print 'Free Space'

  print '----------'

  exec master.dbo.xp_fixeddrives

  print 'Memory'

  print '------'

  exec master.dbo.xp_msver

  print 'Database Configuration'

  print '----------------------'

  exec master.dbo.sp_configure

  print'DB Size'

  print'-------'

  exec master.dbo.sp_databases

  print 'Linked Servers'

  print '--------------'

  exec master.dbo.sp_helplinkedsrvlogin

  print 'Windows info'

  print '------------'

  exec master.dbo.sp_server_info

  

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• SeeCoolGuy

  SSCrazy

  Points: 2902

  More actions

  February 16, 2005 at 10:07 am

  #542592

  VERY COOL!

  thank you...

  -- Francisco