Re: Deadlock on SBS2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 10:03:43 -0500

Has the amount of traffic increased? Do you still have the earlier version
running (like your test machines)? Can you do a side by side comparison and
trace to see if there are differences? Also check all of the system and
connection settings to see if they have changed from your previous version.

Is the only change that was made the underlying OS? 

-- 
----------------------------------------------------------------------------
Louis Davidson (drsql@hotmail.com)
Compass Technology Management
Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266
Note: Please reply to the newsgroups only unless you are
interested in consulting services.  All other replies will be ignored :)
"AlexEg" <AlexEg@mail.com> wrote in message
news:uPK1X42MEHA.2064@TK2MSFTNGP12.phx.gbl...
> I have two apllication connecting to SQL2000. First use ODBC, second -
OLEDB. When the server is
> Windows2000 + SQL2000 everything is ok. But when the system is Small
Business Server 2003
> (Windows2003 + SQL2000) there are too many deadlocks on transactions.
>
> Have you any idea where should be problem? Can be on SQL2000 for SBS2003
different default setting?
> Thanks, Alex.

Relevant Pages

  • RE: Somehow created subdomain of SBS domain
    ... bottom line is I'd recommend you backup your Exchange store to PSTs so ... Some machines may have to uninstall, maybe disable Server applications. ... > our software on a variety of test machines. ... > with some sort of a trust to our SBS domain. ...
    (microsoft.public.windows.server.sbs)
  • Re: Auto completion based on selection of Drop down menu item (Word)
    ... Properties dialog, you choose the macro to be the field's Exit macro, ... several/many computers that all have access to a central server; ... If the amount of data is larger than a few dozen items, ... worksheet, a database... ...
    (microsoft.public.word.tables)
  • Re: Restaurant Rules as written by your server
    ... but I do vary the amount depending on quality of service and cost of food. ... my tip will go up because the server ... part of the meal -- that is, raise the cost of meals and let me see exactly ...
    (rec.food.cooking)
  • maximum users on shared drive
    ... hard-coded limit on the Operating System. ... round it is to upgrade to the Server version. ... >added into that group that needed access to the data. ... >the amount of people that can access the drive at the same ...
    (microsoft.public.security)
  • IIS + BinaryFormatter + LOTS of data
    ... We need to transfer a large amount of data in a remoting ... T1 on the server and DSL/Cable on the client. ... exchanged in one remoting call when using IIS? ...
    (microsoft.public.dotnet.framework.remoting)