dbTalk Databases Forums  

SQL Server 2005 on Windows Server 2008

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts SQL Server 2005 on Windows Server 2008

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL Server 2005 on Windows Server 2008 in the microsoft.public.sqlserver.dts forum.



Reply
Page 3 of 3 < 1 2 3
 
Thread Tools Display Modes
  #21  
Old   
Russell Fields
 
Posts: n/a

Default Re: SQL Server 2005 on Windows Server 2008 - 11-18-2008 , 08:34 AM





ggreeson,

Ah, DTC! (Sorry that I did not guess that.)

There may be many efficiencies in Windows 2008 that might move you to
upgrade, but I doubt that DTC is significantly different. Since it
communicates between machines to manage the distributed transaction, there
is a certain amount of unavoidable overhead.

Perhaps if someone knows better, they will comment. You might also post to
..server or .programming to see if you can get more help.

RLF


"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote

Quote:
I typed DTS but meant DTC or Distributed Transaction Coordinator.

"Russell Fields" wrote:

ggreeson,

Do you mean: Is SQL Server Data Transformation Services (DTS)
significantly
improved by Windows Server 2008? That answer is 'No, not really.' DTS
is
still running as a legacy service from SQL Server 2000.

Or, were you referring to some other DTS?

RLF

"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote in message
news:011BA110-F134-49E7-A42E-8E25DBB2BB69 (AT) microsoft (DOT) com...
Are there DTS improvements in Windows Server 2008 that would justify
upgrading from Windows 2003 to Windows 2008? The SQL Server instance
we
currently have is not in a cluster. I've read about improvements for
clustering, but haven't seen anything else about improvements.


Reply With Quote
  #22  
Old   
Russell Fields
 
Posts: n/a

Default Re: SQL Server 2005 on Windows Server 2008 - 11-18-2008 , 08:34 AM





ggreeson,

Ah, DTC! (Sorry that I did not guess that.)

There may be many efficiencies in Windows 2008 that might move you to
upgrade, but I doubt that DTC is significantly different. Since it
communicates between machines to manage the distributed transaction, there
is a certain amount of unavoidable overhead.

Perhaps if someone knows better, they will comment. You might also post to
..server or .programming to see if you can get more help.

RLF


"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote

Quote:
I typed DTS but meant DTC or Distributed Transaction Coordinator.

"Russell Fields" wrote:

ggreeson,

Do you mean: Is SQL Server Data Transformation Services (DTS)
significantly
improved by Windows Server 2008? That answer is 'No, not really.' DTS
is
still running as a legacy service from SQL Server 2000.

Or, were you referring to some other DTS?

RLF

"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote in message
news:011BA110-F134-49E7-A42E-8E25DBB2BB69 (AT) microsoft (DOT) com...
Are there DTS improvements in Windows Server 2008 that would justify
upgrading from Windows 2003 to Windows 2008? The SQL Server instance
we
currently have is not in a cluster. I've read about improvements for
clustering, but haven't seen anything else about improvements.


Reply With Quote
  #23  
Old   
Russell Fields
 
Posts: n/a

Default Re: SQL Server 2005 on Windows Server 2008 - 11-18-2008 , 08:34 AM


ggreeson,

Ah, DTC! (Sorry that I did not guess that.)

There may be many efficiencies in Windows 2008 that might move you to
upgrade, but I doubt that DTC is significantly different. Since it
communicates between machines to manage the distributed transaction, there
is a certain amount of unavoidable overhead.

Perhaps if someone knows better, they will comment. You might also post to
..server or .programming to see if you can get more help.

RLF


"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote

Quote:
I typed DTS but meant DTC or Distributed Transaction Coordinator.

"Russell Fields" wrote:

ggreeson,

Do you mean: Is SQL Server Data Transformation Services (DTS)
significantly
improved by Windows Server 2008? That answer is 'No, not really.' DTS
is
still running as a legacy service from SQL Server 2000.

Or, were you referring to some other DTS?

RLF

"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote in message
news:011BA110-F134-49E7-A42E-8E25DBB2BB69 (AT) microsoft (DOT) com...
Are there DTS improvements in Windows Server 2008 that would justify
upgrading from Windows 2003 to Windows 2008? The SQL Server instance
we
currently have is not in a cluster. I've read about improvements for
clustering, but haven't seen anything else about improvements.


Reply With Quote
  #24  
Old   
Russell Fields
 
Posts: n/a

Default Re: SQL Server 2005 on Windows Server 2008 - 11-18-2008 , 08:34 AM


ggreeson,

Ah, DTC! (Sorry that I did not guess that.)

There may be many efficiencies in Windows 2008 that might move you to
upgrade, but I doubt that DTC is significantly different. Since it
communicates between machines to manage the distributed transaction, there
is a certain amount of unavoidable overhead.

Perhaps if someone knows better, they will comment. You might also post to
..server or .programming to see if you can get more help.

RLF


"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote

Quote:
I typed DTS but meant DTC or Distributed Transaction Coordinator.

"Russell Fields" wrote:

ggreeson,

Do you mean: Is SQL Server Data Transformation Services (DTS)
significantly
improved by Windows Server 2008? That answer is 'No, not really.' DTS
is
still running as a legacy service from SQL Server 2000.

Or, were you referring to some other DTS?

RLF

"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote in message
news:011BA110-F134-49E7-A42E-8E25DBB2BB69 (AT) microsoft (DOT) com...
Are there DTS improvements in Windows Server 2008 that would justify
upgrading from Windows 2003 to Windows 2008? The SQL Server instance
we
currently have is not in a cluster. I've read about improvements for
clustering, but haven't seen anything else about improvements.


Reply With Quote
  #25  
Old   
Russell Fields
 
Posts: n/a

Default Re: SQL Server 2005 on Windows Server 2008 - 11-18-2008 , 08:34 AM


ggreeson,

Ah, DTC! (Sorry that I did not guess that.)

There may be many efficiencies in Windows 2008 that might move you to
upgrade, but I doubt that DTC is significantly different. Since it
communicates between machines to manage the distributed transaction, there
is a certain amount of unavoidable overhead.

Perhaps if someone knows better, they will comment. You might also post to
..server or .programming to see if you can get more help.

RLF


"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote

Quote:
I typed DTS but meant DTC or Distributed Transaction Coordinator.

"Russell Fields" wrote:

ggreeson,

Do you mean: Is SQL Server Data Transformation Services (DTS)
significantly
improved by Windows Server 2008? That answer is 'No, not really.' DTS
is
still running as a legacy service from SQL Server 2000.

Or, were you referring to some other DTS?

RLF

"ggreeson" <ggreeson (AT) discussions (DOT) microsoft.com> wrote in message
news:011BA110-F134-49E7-A42E-8E25DBB2BB69 (AT) microsoft (DOT) com...
Are there DTS improvements in Windows Server 2008 that would justify
upgrading from Windows 2003 to Windows 2008? The SQL Server instance
we
currently have is not in a cluster. I've read about improvements for
clustering, but haven't seen anything else about improvements.


Reply With Quote
Reply
Page 3 of 3 < 1 2 3

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top