Viewing 15 posts - 11,611 through 11,625 (of 49,552 total)
Memory pressure won't necessarily cause slow queries.
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
September 23, 2013 at 6:38 am
Marek Grzymala (9/23/2013)
Aren't both errors in effect caused by TRUNCATE_ONLY (which breaks the LSN, deosn't it) from step 2?
The first one is, but the second occurs when you've forked 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
September 23, 2013 at 6:36 am
Try a server-side trace.
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
September 23, 2013 at 12:09 am
How big does TempDB get? Take that size, divide by the number of files, add a bit extra for safety.
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
September 22, 2013 at 2:38 pm
Does the table have a clustered index? The presence or absence of non-clustered indexes is irrelevant when trying to move the 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
September 22, 2013 at 8:06 am
There is no database ID for ad-hoc queries. You could try parsing the statement and figuring out which tables it uses and which DB those are in.
But then, what database...
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
September 22, 2013 at 7:29 am
Short of parsing the ad-hoc statement, figuring out which tables are there and linking them to a DB, you don't.
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
September 22, 2013 at 5:09 am
Do Not add SQL Server to the administrators group. That's a bad security practice, SQL does not need to be administrator and should not be administrator.
After granting the SQL Server...
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
September 22, 2013 at 5:09 am
Zeal-DBA (9/21/2013)
i already configured AWE enable and max server memory to 24 GB, i dont think its in effect because it shows in task manager only 3.5 GB consume.
Because locked...
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
September 21, 2013 at 3:15 pm
No, that's the complete opposite of what I'm explaining.
The FILE = is necessary when multiple different backups have been made to the same file. Your example shows one backup 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
September 21, 2013 at 3:10 pm
Welcome to 'it depends' 🙂
If you want to do fast loads and fast deletes (switch partitions in/out), then partition. If you want to do index maintenance at the partition level,...
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
September 21, 2013 at 2:53 am
C.K.Shaiju (9/21/2013)
Thanks, have read that clustering and mirroring required new addition of hardware and software
Virtual machines. No additional hardware necessary.
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
September 21, 2013 at 2:51 am
It's specifying the file within the backup, not the file or filegroup. Only necessary if you append multiple backups to the same backup file and want to restore a backup...
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
September 21, 2013 at 2:51 am
No.
Moving to another server can be done with minimal downtime by using log shipping or mirroring, but there will still be a small amount. Moving the DB to another drive...
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
September 20, 2013 at 5:03 pm
The error message (out of memory) is a client-side error. It's not SQL Server that's running out of memory, it's the client application (Management studio). There's no option in SQL...
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
September 20, 2013 at 5:01 pm
Viewing 15 posts - 11,611 through 11,625 (of 49,552 total)