Viewing 15 posts - 7,501 through 7,515 (of 49,571 total)
I'm noticing the biggest slowdown to be when reading threads and on the 'posts since my last visit/posts added today'
October 15, 2014 at 10:18 am
That's a little on the high side. The OS needs memory to manage memory and it doesn't much like being starved.
October 15, 2014 at 10:10 am
I'm sure I've given you this link before.
October 15, 2014 at 6:39 am
Index rebuild, maybe, depends on how you partition and whether you need to rebuild all partitions or not. Bear in mine that online rebuilds can't be done at the partition...
October 15, 2014 at 6:32 am
If you wrote 5 delete statements in a single procedure, they will be executed one by one. SQL does not run multiple statements in a stored proc in parallel.
October 15, 2014 at 6:20 am
smtzac (10/15/2014)
For the performance reason. they want to partition 2 big table.
Then don't waste your time. Partitioning is not for performance reasons. It's not a magic go-faster feature.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
October 15, 2014 at 6:17 am
Create an extended events session or server-side trace to record what's running against the server. Let it run long enough to catch a good sample of data. Look at the...
October 15, 2014 at 5:33 am
TheSQLGuru (10/15/2014)
A proper profiler-to-local-disk script can be run to capture heavy CPU users with very little overhead on the system.
And an extended events session will have even less.
October 15, 2014 at 5:20 am
Sysprocesses is useless for this, it's the cumulative totals since SQL started, so of course the system processes will show high.
Did you have any form of extended events trace running...
October 15, 2014 at 4:17 am
Why are you trying to run part of the procedure's definition rather than creating the procedure and running it?
And why is the procedure recursive?
October 15, 2014 at 3:02 am
If you just execute the part after the nocount, then the parameter hasn't been declared and hence you get exactly the error you posted.
If you're trying to run just this,...
October 15, 2014 at 2:40 am
Not with Availability Groups. Secondary replicas are read-only.
The new tables/views are just in the reporting database and don't need to be written back to the primary system?
October 15, 2014 at 2:26 am
Sleeping is a connection that's not doing anything. It's not waiting for anything (other than more work to do), it's not taking up CPU, it's not doing any work.
October 14, 2014 at 8:17 am
Steve Jones - SSC Editor (10/14/2014)
Is quoting and general access slow for anyone else today?
Yes. And yesterday.
October 14, 2014 at 8:14 am
Koen Verbeeck (10/14/2014)
You forgot the END.
Alternatively, you have a stray BEGIN.
BEGIN ... END aren't necessary for a stored proc.
October 14, 2014 at 6:16 am
Viewing 15 posts - 7,501 through 7,515 (of 49,571 total)