Viewing 15 posts - 7,501 through 7,515 (of 49,552 total)
I'm noticing the biggest slowdown to be when reading threads and on the 'posts since my last visit/posts added today'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2014 at 10:10 am
I'm sure I've given you this link before.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 14, 2014 at 6:16 am
Viewing 15 posts - 7,501 through 7,515 (of 49,552 total)