Tuesday, May 14, 2013

[MS SQL Server] SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds

[MS SQL Server] SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds

SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds

Posted: 14 May 2013 03:45 AM PDT

I am running SQL Server 2008 R2 SP2 x64 and we just increased the RAM to 32GB (against my wishes) we are not getting the SQL Server has encountered 1 occurrence of I/O Requests taking longer than 15 seconds error. Could Could the RAM increase be the cause of this. Im thinking that SQL is now moving too fast for the hard drive to keep up with?Please adviseTanya

DB mirroring between SQL 2005 and SQL 2008 R2

Posted: 13 May 2013 11:47 PM PDT

Is it possible to setup DB mirroring between SQL 2005 as primary and SQL 2008 R2 as Mirror.

MAXDOP settings for OLAP

Posted: 14 May 2013 12:27 AM PDT

Hello, Does anyone have any idea what is the better way to set MAXOP settings for OLAP system. Here is my environment info:SQLServer: 2008 R2LOGICAL CPU Count: 40Hyperthread ration : 10Physical CPU Count : 4Physical memory : 260 GBI have seen one of the forumale and not so sure is this right setting:--MAX DEGREE OF PARALLELISM FORUMLAE--'4' NUMBER OF PROCESSESSORS- 4/2 = 2select case when cpu_count / hyperthread_ratio > 2 then 2 else cpu_count / hyperthread_ratio end as optimal_maxdop_settingfrom sys.dm_os_sys_info;O/P: 2--Another formulae:declare @hyperthreadingRatio bitdeclare @logicalCPUs intdeclare @HTEnabled intdeclare @physicalCPU intdeclare @SOCKET intdeclare @logicalCPUPerNuma intdeclare @NoOfNUMA intselect @logicalCPUs = cpu_count -- [Logical CPU Count] ,@hyperthreadingRatio = hyperthread_ratio -- [Hyperthread Ratio] ,@physicalCPU = cpu_count / hyperthread_ratio -- [Physical CPU Count] ,@HTEnabled = case when cpu_count > hyperthread_ratio then 1 else 0 end -- HTEnabledfrom sys.dm_os_sys_infooption (recompile);select @logicalCPUPerNuma = COUNT(parent_node_id) -- [NumberOfLogicalProcessorsPerNuma]from sys.dm_os_schedulerswhere [status] = 'VISIBLE ONLINE' and parent_node_id < 64group by parent_node_idoption (recompile);select @NoOfNUMA = count(distinct parent_node_id)from sys.dm_os_schedulers -- find NO OF NUMA Nodes where [status] = 'VISIBLE ONLINE' and parent_node_id < 64-- Report the recommendations ....select --- 8 or less processors and NO HT enabled case when @logicalCPUs < 8 and @HTEnabled = 0 then 'MAXDOP setting should be : ' + CAST(@logicalCPUs as varchar(3)) --- 8 or more processors and NO HT enabled when @logicalCPUs >= 8 and @HTEnabled = 0 then 'MAXDOP setting should be : 8' --- 8 or more processors and HT enabled and NO NUMA when @logicalCPUs >= 8 and @HTEnabled = 1 and @NoofNUMA = 1 then 'MaxDop setting should be : ' + CAST(@logicalCPUPerNuma / @physicalCPU as varchar(3)) --- 8 or more processors and HT enabled and NUMA when @logicalCPUs >= 8 and @HTEnabled = 1 and @NoofNUMA > 1 then 'MaxDop setting should be : ' + CAST(@logicalCPUPerNuma / @physicalCPU as varchar(3)) else '' end as RecommendationsO/P: 2Not so sure, are these correct or not. Need suggestions please. Thanks

SQl Agent job when query fails to return result

Posted: 13 May 2013 06:57 AM PDT

Hello,I am trying to put in place a job which will email me when a query fails to return results: This is query and if it returns 0 rows then email SELECT * FROM ::fn_trace_geteventinfo(2)==============I know this is the body of the send_email exec. but how to code it together?EXEC msdb.dbo.sp_send_dbmail @profile_name = 'DBA Alert', @recipients = 'email recipient, @subject = blabla, @body_format = 'HTML', @importance = 'High', @body = @EmailTXT thx

TempDB full

Posted: 13 May 2013 10:02 PM PDT

if Temp Db full which databases will go Offline?

check missing index

Posted: 13 May 2013 09:38 AM PDT

Is there some good queries for checking missing indexes on all tables of a database?THanks

How to copy .bak files on an external drive which is not part of domain but requires authentication?

Posted: 13 May 2013 05:44 PM PDT

We are looking for a solution to copy .bak files on external network drive which does not allow access without loginId and password, we are seeing some intermittent hardware issue with database server, right now the backup is on local db server, which would be useless incase of hardware disaster. so to be on safe side, we arranged a portable device attached as network drive which requires authentication. We want to simply copy that backup file on network drive. How do we do this. the network drive is not part of domain etc. It is independent drive.Please help and provide if there is any solution (Script/ .bat files etc)Shamshad Ali.

Replication -- Will blocking occur at the Subscriber like at the Publisher?

Posted: 13 May 2013 07:36 AM PDT

Hello, I have a table on Database A that is frequently updated by Application A. Application B needs to frequently SELECT from this table in a time critical process, so obviously some blocking occurs.I was thinking of Replicating the table to Database B and do the SELECT from that table.What I am unsure of if I will get exactly the same symptoms i.e if an UPDATE lock occurs on Database A (Publisher) therefore blocking SELECTS then an UPDATE lock will also occur on Database B (Subscriber) therefore still blocking SELECTs...so basically more complexity for no gain!!!Is this what would happen?thanks

table for inner join

Posted: 13 May 2013 08:57 AM PDT

When I do an inner join of two tables: table 1 and table 2, does the postion of the table matters ?I mean on the left or right of the inner join, for examplebelow, do they make any difference?table1 inner join table2or table2 inner join table1
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog