Monday, September 2, 2013

[MS SQL Server] high cpu and parallelism

[MS SQL Server] high cpu and parallelism

high cpu and parallelism

Posted: 02 Sep 2013 01:58 AM PDT

Hi Everyone,I was just doing a read-up upon high-cpu and CXPACKET wait/parallelism.One thing, which is over my reach is below statement."worker time is greater than its elapsed time is a great indication of parallelism"Can anyone please explain an example how could it be possible cpu> total elapsed time. How this is possible? Again i am just learner and I wanted to know who this can happen in real time?Looking for brief explanation on this.Thanks in Advance

unable to connect to server

Posted: 01 Sep 2013 11:43 PM PDT

Hi all.here we are trying to connect to server which is not accessible and it through the below error.Error:The operating system returned error 2(The system cannot find the file specified.) to SQL Server during a write at offset 0x00000230b20000 in file 'H:\Data\TempDB\tempdb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.The operating system returned error 2(The system cannot find the file specified.) to SQL Server during a read at offset 0000000000000000 in file 'H:\Data\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.We checked through the event logs and found that there were fatal errors on drive, and looks like disk issue. An error was detected on device \Device\Harddisk1\DR1 during a paging operation.A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 10054, output error: 0).we have restarted the server but it is not yet up.

The package execution returned DTSER_FAILURE (1)

Posted: 01 Sep 2013 07:59 PM PDT

Hi I am having a problem when running a maintenance plan(full database backup) in my environment as i get the error bellow.I have recreated the backup plan but still get that error.MessageExecuted as user: Nombert\SQLCCL01. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 09:49:13 AM Progress: 2013-09-02 09:49:14.78 Source: {B4178225-76AA-4D5D-9F6D-3EEEE53B656D} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2013-09-02 09:49:14.84 Source: Maintenance Cleanup Task Executing query "EXECUTE master.dbo.xp_delete_file 0,N'J:\MSSQL10_5...".: 100% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 25% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 50% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 75% complete End Progress Progress: 2013-09-02 09:49:15.17 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'J:\MSSQL10_5...".: 100% complete End Progress Progress: 2013-09-02 09:49:15.78 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [master] TO DISK = N'J:\MSSQL10_5...".: 100% complete End Progress Progress: 2013-09-02 09:49:16.18 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [model] TO DISK = N'J:\MSSQL10_50...".: 100% complete End Progress Progress: 2013-09-02 09:49:17.42 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [msdb] TO DISK = N'J:\MSSQL10_50....".: 100% complete End Progress Error: 2013-09-02 09:49:17.56 Code: 0xC002F210 Source: Back Up Database (Full) Execute SQL Task Description: Executing the query "BACKUP DATABASE [RiskAnalytics_Prod_Archive ] TO ..." failed with the following error: "Cannot open backup device 'J:\MSSQL10_50.SLQnombert\MSSQL\Backup\Full_Backup\Nombertprod ombertprod_backup_2013_09_02_094915_1589136.bak'. Operating system error 3(failed to retrieve text for this error. Reason: 15105). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 09:49:13 AM Finished: 09:49:17 AM Elapsed: 3.681 seconds. The package execution failed. The step failed.

Emailing from SQL 2008 using 'EX:\O' type addresses

Posted: 14 Aug 2013 09:44 PM PDT

I'm trying to do the simple task of sending emails to end-users when their case is closed on the database.Normally I simply use DBMail and sp_send_mail; no problems.But the only email addresses available are of the form 'EX:/O=xxx/OU=site/cn=Recipients/cn=nnn.mmmm' which I am given to understand arise from Exchange. Anyway I can't get them to work, and so far haven't found anything about it on the net.Anyone have an idea? All offers gratefully accepted.thanks
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog