Viewing 15 posts - 106 through 120 (of 194 total)
SET STATISTICS TIME ON, run the SP and check the messages tab.
Alternatively this view sys.dm_exec_query_stats has elapsed time columns.
'Only he who wanders finds new paths'
March 19, 2013 at 9:17 am
Well we were mainly moving to new structures so the migration was two part, moving recent data to a faster server and the older data shifted to cheaper archive storage....
'Only he who wanders finds new paths'
March 18, 2013 at 2:55 pm
Apologies, I am not sure what you are asking.
If it what action to take next, then it depends on the requirements of the business perhaps. Is the data that...
'Only he who wanders finds new paths'
March 18, 2013 at 8:10 am
We have done similar things in the past, essentially using SSIS to archive/move data to a new server. On enterprise you could partition the data instead.
'Only he who wanders finds new paths'
March 18, 2013 at 4:00 am
OK, SQL Agent is for jobs so non essential, or rather not related to this problem. SQL Browser would be the one to check. Can you post the...
'Only he who wanders finds new paths'
March 17, 2013 at 8:56 am
How are you attempting to connect, SSMS? All services running? Can you connect with a sql login?
'Only he who wanders finds new paths'
March 17, 2013 at 3:39 am
Is the original source database used purely for this reporting access or are there other production processes going on? If it is used for a bundle of things then...
'Only he who wanders finds new paths'
March 15, 2013 at 8:06 am
Have you tried removing the index hint, just to guage any difference in performance?
What I would do, as suggested, is move all csv rows into a staging table, perform DELETE...
'Only he who wanders finds new paths'
March 15, 2013 at 6:36 am
We have several data capture systems where we utilise transactional replication for reporting purposes. I used to think it was a little misuse of a high availability solution but...
'Only he who wanders finds new paths'
March 15, 2013 at 6:12 am
Absolutely re the above.
I use the following query with getdate in there and schedule it once per hour (with a clear of the waits afterwards) to monitor peaks...
'Only he who wanders finds new paths'
March 15, 2013 at 5:35 am
Might help...
If the query plan that is specified by using plan_handle has been evicted from the plan cache, the query_plan column of the returned table is null. For example, this...
'Only he who wanders finds new paths'
March 15, 2013 at 3:23 am
I might be confused, is it the xml plans that come up in the results, or an execution plan of the query you posted?
'Only he who wanders finds new paths'
March 14, 2013 at 1:20 pm
MyDoggieJessie (3/13/2013)
You can also create custom alerts (in your SQL Server Agent >> Alerts) via the...
'Only he who wanders finds new paths'
March 14, 2013 at 9:37 am
Presumably the plans are simply not in the cache any more. Can you re-run any of the queries and requery the DMV to see if it then appears?
'Only he who wanders finds new paths'
March 14, 2013 at 9:33 am
Sound advice above and much better than the words I had scribbled down 🙂
I let the business needs determine the backup strategy to a point. For example, if a...
'Only he who wanders finds new paths'
March 14, 2013 at 6:18 am
Viewing 15 posts - 106 through 120 (of 194 total)