Viewing 15 posts - 1,186 through 1,200 (of 2,462 total)
Use below queries for troubleshoot.these would be more informative.
--use ESS_ARCHIVE
--select * from sys.dm_os_wait_stats
select r.cpu_time
, r.logical_reads
, r.session_id
into #temp
from sys.dm_exec_sessions as s
inner join sys.dm_exec_requests as r
on s.session_id...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2010 at 1:30 am
pujain (11/11/2010)
Hi all,I am facing an issue where my update statement is blocked by below statement(Inactive):
"use dbname"
is any body having an idea why? and whats the workaround to avoid.
thanks
Puneet
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 11, 2010 at 1:27 am
Thanks to OP and special thanks to HUGO for great explanation.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 9, 2010 at 12:24 am
GilaMonster (11/8/2010)
Why? What's the reasoning behind that odd limitation/restriction?
This was asked by one of my friend during a quiz
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2010 at 9:34 pm
How
count(*) over (partition by 1)
section is working here ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2010 at 6:43 am
thanks dave , but some times i get error that i need to use "order by" with "partition by" , Any idea ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2010 at 6:41 am
muthukkumaran (11/8/2010)
1.Backup --yes (Except tempdb)
2.Reorganize Index --no
3.checkdb --yes (Except tempdb)
4.Update Statistics --no
What about MSDB ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 8, 2010 at 6:38 am
Our Secondary server is more often in recovering or stand by state and we made it by restoring the full back up of primary one. after that sequence Tlogs from...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 7, 2010 at 10:23 pm
Did you check the the log_shipping_alert job (which get created when we use wizard) ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 4, 2010 at 6:22 am
RPSql (11/3/2010)
An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException'...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 11:03 pm
you can also set profiler trace and check other child SPs which might be cause of bad performance.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 10:59 pm
sqldba_icon (11/3/2010)
but indexes are used on queries based on statistics and statistics are stored inside master database of local server. Am i missing anything here?
In simple language i would...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 10:52 pm
Yes, the operation is fully logged, so the indexes on the secondary server will be rebuilt automatically.
However, we don’t recommend that you rebuild indexes often for a log shipping scenario...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 10:34 pm
You can also set a maintenace task or job to rebuild/reorganize the only required indexes OR might be on the required database instead of selecting all DBs
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 5:40 am
Raghavender (10/26/2010)
fragmentation is more than 10%.
Are you sure ? i think it should be around 70-80%.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
November 3, 2010 at 4:55 am
Viewing 15 posts - 1,186 through 1,200 (of 2,462 total)