Viewing 15 posts - 20,266 through 20,280 (of 49,552 total)
Either works. Backup-restore is far less work and should be quicker.
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
February 16, 2012 at 3:05 pm
Good to hear.
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
February 16, 2012 at 2:57 pm
28 C, gorgeous summer day, and a late afternoon storm to cool things down for the evening.
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
February 16, 2012 at 11:54 am
That's most likely data caching (data pages cached in the buffer pool), not plan caching as the plan would have been reused for all unless you did something to clear...
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
February 16, 2012 at 11:22 am
Unless you have custom auditing or something like SQLAudit, there is no way to retrieve that information. SQL just doesn't keep it by default.
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
February 16, 2012 at 10:16 am
Dunno about worse, but definitely shorter
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
February 16, 2012 at 9:24 am
It'll let you restore a SQL 2005 backup to it, yes (providing the database is under 4GB in size), however once the database is on that instance you will not...
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
February 16, 2012 at 8:21 am
Please post new questions in a new thread, that has nothing to do with backup files
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
February 16, 2012 at 7:31 am
If you're referring to the avatar, that's a picture from one of the StarWars movies.
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
February 16, 2012 at 7:13 am
Grant Fritchey (2/16/2012)
The real shocker is that you don't occasionally get the 30 minute execution anyway.
Variables, not parameters, so no parameter sniffing and the optimiser probably mis-guessing the row counts....
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
February 16, 2012 at 6:19 am
Jody.WP (2/16/2012)
By archiving your non operational(referenced data older than 3 months) you should reduce your db size which should reduce your log file.
That would only be true if the monthly...
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
February 16, 2012 at 6:18 am
Yes, you should get more space. That or look at why the month end imports are using that much log space and see if there's anything that can be done...
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
February 16, 2012 at 6:17 am
High memory usage (which is what Idera is picking up) does not automatically mean memory pressure. It just means that a lot of memory is in use. That's generally a...
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
February 16, 2012 at 4:16 am
Ok, take a step back...
What report contains 5 million records? No one is ever going to read 5 million rows, so what's the purpose of the report?
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
February 16, 2012 at 3:47 am
If SQL is using too much memory, reduce the max server memory setting a little.
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
February 16, 2012 at 3:46 am
Viewing 15 posts - 20,266 through 20,280 (of 49,552 total)