Viewing 15 posts - 17,401 through 17,415 (of 49,552 total)
Index tuning wizard was the SQL 2000 and prior tool that was renamed Database Tuning Adviser in 2005.
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
July 26, 2012 at 2:56 am
SQL* (7/25/2012)
Here memory means the RAM size right? If i have more memory then this limitation will be exceeded (more than 5000 locks).
Yes, memory=RAM in this case. No, 5000 locks...
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
July 26, 2012 at 2:43 am
What are the exact definitions of those two indexes?
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
July 25, 2012 at 4:32 pm
randerson-917627 (7/25/2012)
eventclass: SQL:BatchCompleted
textdata: SET TRANSACTION ISOLATION LEVEL READ COMMITTED
I understand what that is doing; what I'm having trouble...
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
July 25, 2012 at 1:21 pm
I bought The Disappearing Spoon. It's awesome.
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
July 25, 2012 at 1:00 pm
Best thing I can suggest is schedule the backup for the lowest usage time, you'll have to monitor to see when that is.
Also, if you're using a SAN, speak to...
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
July 25, 2012 at 12:25 pm
If it's IO related it'll potentially slow down all databases on the same storage. It's a fair bit more complex though, depends on whether data is in cache or disk,...
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
July 25, 2012 at 12:15 pm
That's to be expected. Backups drive a lot of IO, if the IO subsystem can't handle the load it'll slow everything down, backups and user queries.
Are you compressing the backups?...
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
July 25, 2012 at 11:20 am
Temp table, yes. Table variable, no.
It's not a full recompile, just any statements that use the newly created or altered table
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
July 25, 2012 at 11:15 am
Not automatically it won't. Nothing special about those two commands together.
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
July 25, 2012 at 10:48 am
Little Nick (7/25/2012)
1. What's the different between shrink data file and shrink log file?
One shrinks the data file, one shrinks the log file.
2. Which one (shrink data / shrink...
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
July 25, 2012 at 10:29 am
Can someone with more patience than I have please help here: http://www.sqlservercentral.com/Forums/Topic1334377-391-1.aspx?
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
July 25, 2012 at 10:21 am
Brandie Tarvin (7/25/2012)
Where did he get the idea that DELETED is a reserved word in T-SQL?
Probably from the deleted and inserted tables in triggers (which he says no one...
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
July 25, 2012 at 10:20 am
No and no. 5000 locks (there is a memory threshold, but you shouldn't hit that unless escalation's been disabled)
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
July 25, 2012 at 10:18 am
Not sure then, the two reasons I know of are SSIS not installed on the server that's running the jobs or running standard edition and using enterprise features.
Can you google...
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
July 25, 2012 at 10:17 am
Viewing 15 posts - 17,401 through 17,415 (of 49,552 total)