Viewing 15 posts - 31 through 45 (of 152 total)
Andrew G (1/19/2015)
For example, you...
January 20, 2015 at 1:21 am
Has 'locked pages' in memory configured for this server?
If there are non sql or non buffer pool activity that require more memory it might be clearing it earlier too?
January 9, 2015 at 7:11 pm
Thanks Gail!
I think I will have to 're-run' my testing, I used the following to check for parallel plans.
SELECT TOP 50
OBJECT_NAME(p.objectid, p.dbid) as [object_name]
,ps.total_worker_time/ps.execution_count as avg_worker_time
,ps.execution_count
,ps.total_worker_time
,ps.total_logical_reads
,ps.total_elapsed_time
,p.query_plan
,q.text
,cp.plan_handle
FROM sys.dm_exec_procedure_stats ps
INNER JOIN sys.dm_exec_cached_plans...
December 5, 2014 at 11:49 am
Welsh Corgi (12/5/2014)
I had a script that identifies the Percent Complete of a Restore, etc.I can not find it.
Any help would be greatly appreciated.
Thanks.
Kent
I got this from some where and...
December 5, 2014 at 11:25 am
JoshDBGuy (12/3/2014)
So it doesn't look like we use RDM. Basically we have storage assigned to a host and then spread out that storage among virtual machines.
Hi Josh not sure if...
December 3, 2014 at 1:41 pm
Thanks SpaghettiaDBA and ScottPletcher for your feedback! I appreciate it 😀
December 3, 2014 at 11:19 am
spaghettidba (12/2/2014)
Stale statistics could be the cause.Plans compiled against stale statistics are more likely to be sub-optimal.
That's a possibility thanks!
So maybe the long running plan was using stale stats......
December 2, 2014 at 7:41 pm
tpsharp (12/2/2014)
There are definitely VM snapshots occurring, I will check out and see when they run to see if this is causing this.
Many thanks everyone for your help.
This normally happens...
December 2, 2014 at 4:40 pm
spaghettidba (11/21/2014)
Looks like bad parameter sniffing and/or stale statistics.Here's a good article on the subject: http://www.mssqltips.com/sqlservertip/3257/different-approaches-to-correct-sql-server-parameter-sniffing/
Thanks for reply and link. I would think so too, but if the cache is...
December 2, 2014 at 4:11 pm
Interesting :unsure:
Are your drives separated by
LOG
DATA
If so, could it be possible the LOG drive is slower than DATA drive?
I know that for rebuild and reorg there is log...
November 7, 2014 at 4:54 pm
Priya004 (9/18/2014)
Hi,Need a query to compre two database schemas.
I have seen lot of comparision tools but need a query.
Thanks
Do you have replication installed on a (it can be any) SQL...
September 19, 2014 at 2:55 am
GilaMonster (9/11/2014)
sqlsurfing (9/10/2014)
I think i'll focus on working w/developer on any tweaks first on that blocking sproc first.
Good idea. Can't see anything in the code you...
September 19, 2014 at 2:52 am
TomThomson (12/7/2010)
September 15, 2014 at 7:28 pm
pawana.paul (9/10/2014)
To analyze the performance data I am inserting SYS.DM_EXEC_REQUESTS DMV result into table. Under the Command column, it shows CREATE INDEX entries, under Text column it shows insert [dbo].[tblName1]...
September 10, 2014 at 9:03 pm
i_amhers (9/10/2014)
Without reading the transaction log and/or log backups (which may be impossible, if msdb is set to the default simple recovery), I am not sure there is a...
September 10, 2014 at 8:58 pm
Viewing 15 posts - 31 through 45 (of 152 total)