BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  MS SQL 2k quirky hangup          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Thomas J. Theobald Guest Posted: Mon Apr 26, 2004 9:30 pm    Post subject: MS SQL 2k quirky hangup Hmmm...anyone seen this before? We've got an installation of MS SQL 2k on a dual-CPU box. System has about 100G free on the drive hosting the database, 50G free on the log drive, and 30G free on the OS host drive. Of the 2G memory, task manager and the stats manager in MS SQL concur that it fluctuates around 50-70% usage, and the CPU goes anywhere from 1% to 80% at any given polling time. Here's the weird part. The logged-in desktop is locked up - can't start other apps, can't read files, can't do a thing (can't even shut down the PC). Users connected to the database report no loss of functionality or performance. This issue seems to have begun last night, during a scheduled maintenance backup that hung (i.e., it did not back up, it still registers as a live process, but isn't actually doing anything). Three other maintenance backups have all done the same thing since the first one last night. Anyone ever seen this before? Can someone clue me in on where to look to find out more? Thanks - T -- Thomas J. Theobald Application Development Manager MidwayUSA America's Source for Shooting Supplies 5875 W. Van Horn Tavern Road Columbia, MO 65203 [email]ttheobald (AT) midwayusa (DOT) nospamplease.com[/email] www.midwayusa.com 800-243-3220 Back to top Del Murray Guest Posted: Mon Apr 26, 2004 10:53 pm    Post subject: Re: MS SQL 2k quirky hangup What kind of backup were you running. If a full backup , then the log file gets truncated , if that fails, then some bad crap can happen but it can be fixed. Back to top Oscar Santiesteban Jr. Guest Posted: Tue Apr 27, 2004 4:31 am    Post subject: Re: MS SQL 2k quirky hangup Thomas, This happened to me on a DELL Poweredge Server with Win2k and SQL 2k. It happened when I tried to "backup" a large database. I could never understand why this happened. The workaround in my case was to take the following steps. 1. Drop the "backup device" 2. Create a new backup device 3. Backup the database to this new device. Once I did this, the server never "locked up" like you describe. In my case, the server locked up so bad that SQL would not respond. You are lucky that the users can still get to SQL server. Oscar... "Thomas J. Theobald" <ttheobald (AT) midwayusa (DOT) nospamplease.com> wrote Quote: Hmmm...anyone seen this before? We've got an installation of MS SQL 2k on a dual-CPU box. System has about 100G free on the drive hosting the database, 50G free on the log drive, and 30G free on the OS host drive. Of the 2G memory, task manager and the stats manager in MS SQL concur that it fluctuates around 50-70% usage, and the CPU goes anywhere from 1% to 80% at any given polling time. Here's the weird part. The logged-in desktop is locked up - can't start other apps, can't read files, can't do a thing (can't even shut down the PC). Users connected to the database report no loss of functionality or performance. This issue seems to have begun last night, during a scheduled maintenance backup that hung (i.e., it did not back up, it still registers as a live process, but isn't actually doing anything). Three other maintenance backups have all done the same thing since the first one last night. Anyone ever seen this before? Can someone clue me in on where to look to find out more? Thanks - T -- Thomas J. Theobald Application Development Manager MidwayUSA America's Source for Shooting Supplies 5875 W. Van Horn Tavern Road Columbia, MO 65203 [email]ttheobald (AT) midwayusa (DOT) nospamplease.com[/email] www.midwayusa.com 800-243-3220 Back to top Thomas J. Theobald Guest Posted: Tue Apr 27, 2004 1:32 pm    Post subject: Re: MS SQL 2k quirky hangup It was a full backup, yes - we were also backing up, truncating, and moving the log files in the process. Looks like the first backup to attempt to run just went somewhere during its first steps of running, didn't even create a small backup file. Once it fell, the scheduled jobs to follow also vanished into never-never land. Still trying to ID the problem - restarted the server last night, but no idea what is causing the issue to begin with. T Back to top Del Murray Guest Posted: Wed Apr 28, 2004 1:12 pm    Post subject: Re: MS SQL 2k quirky hangup What happens if you do a full backup manually thru the Enterprise manager ? Back to top Thomas J. Theobald Guest Posted: Wed Apr 28, 2004 2:13 pm    Post subject: Re: MS SQL 2k quirky hangup Right now it works fine, but that's after a restart ). Couldn't have run EM from the console during the problem, but didn't try a backup from a remote machine. If the issue re-arises, I might give that a try. T "Del Murray" <Del.Murray (AT) N_S_CreditHawk (DOT) Net> wrote Quote: What happens if you do a full backup manually thru the Enterprise manager ? Back to top Brett Watters Guest Posted: Wed Apr 28, 2004 2:48 pm    Post subject: Re: MS SQL 2k quirky hangup Thomas, Quote: This issue seems to have begun last night, during a scheduled maintenance backup that hung (i.e., it did not back up, it still registers as a live process, but isn't actually doing anything). Three other maintenance backups have all done the same thing since the first one last night. I hope you aren't attempting to directly back-up the MS SQL directories while they are in use? You can not directly backup (i.e. copy) the MS SQL files on disk. The MDB and log files are not normal files. Remember that MS SQL has them open in an extremely low-level manor and is writing to allocation tables in order to get every once of performance out of the disk system. If a backup program is using the file system to back stuff up, MS SQL can (and does) alter these dynamically to gain maximum performance. This can (temporarily) mean that direct reads to the files fail. Backing up these files isn't necessary anyway. You can't restore these files since they are like big temporary "scratch pads" to MS SQL and are changing constantly -- even when MS SQL isn't processing commands it is reallocating (i.e. altering) space in the tables, preforming cached updates, etc., etc. You should have the MS SQL backup create the backup files for you and then back just these up during a sweep. You should also time you backups such that MS SQL has finished the backup process prior the backup app copying the data to tape (or other media). They are smaller and portable. Thanks, Brett "Thomas J. Theobald" <ttheobald (AT) midwayusa (DOT) nospamplease.com> wrote Quote: Hmmm...anyone seen this before? We've got an installation of MS SQL 2k on a dual-CPU box. System has about 100G free on the drive hosting the database, 50G free on the log drive, and 30G free on the OS host drive. Of the 2G memory, task manager and the stats manager in MS SQL concur that it fluctuates around 50-70% usage, and the CPU goes anywhere from 1% to 80% at any given polling time. Here's the weird part. The logged-in desktop is locked up - can't start other apps, can't read files, can't do a thing (can't even shut down the PC). Users connected to the database report no loss of functionality or performance. This issue seems to have begun last night, during a scheduled maintenance backup that hung (i.e., it did not back up, it still registers as a live process, but isn't actually doing anything). Three other maintenance backups have all done the same thing since the first one last night. Anyone ever seen this before? Can someone clue me in on where to look to find out more? Thanks - T -- Thomas J. Theobald Application Development Manager MidwayUSA America's Source for Shooting Supplies 5875 W. Van Horn Tavern Road Columbia, MO 65203 [email]ttheobald (AT) midwayusa (DOT) nospamplease.com[/email] www.midwayusa.com 800-243-3220 Back to top Del Murray Guest Posted: Wed Apr 28, 2004 3:18 pm    Post subject: Re: MS SQL 2k quirky hangup We were talking about backing them up with Enterprise Manager, not just copying the data and log files. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.