Viewing 15 posts - 11,206 through 11,220 (of 49,552 total)
The only thing I would suggest is give the column a better name. You shouldn't use reserved words or datatype names as column names
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 23, 2013 at 10:50 am
New persopn (10/23/2013)
Please advise me how can i take action here to reduce the log
Have you monitored the used space in the log over the course of several days? If...
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 23, 2013 at 10:48 am
george sibbald (10/23/2013)
4 hours to run checkdb but only 10 mins to backup seems incongruous, I would check that out, what command do you actually run for the checkdb?
And what...
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 23, 2013 at 10:44 am
Before you remove it, ask whether you want to back up a corrupt database. Ask whether you have any way at all to check for corruption and if not whether...
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 23, 2013 at 10:43 am
joshd 1807 (10/23/2013)
The databases are fully functional and aren't restoring any logs, so the error message is confusing.
That message is from the RESTORE DATABASE ... WITH RECOVERY line. Since 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 23, 2013 at 10:33 am
joshd 1807 (10/23/2013)
100% full access. I can access it from the server with the Windows Authentication account I am using
I didn't ask about the account you're using. I asked if...
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 23, 2013 at 10:30 am
Koen Verbeeck (10/23/2013)
Beatrix Kiddo (10/23/2013)
Koen Verbeeck (10/23/2013)
Even hardcore DBAs like Gail, Jeff and others have gaps in their knowledge.
I utterly refuse to believe this :-D.
Ask them about SSIS 🙂
What's SSIS?
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 23, 2013 at 7:01 am
Koen Verbeeck (10/23/2013)
GilaMonster (10/23/2013)
Koen Verbeeck (10/23/2013)
Even hardcore DBAs like Gail, Jeff and others have gaps in their knowledge.
I am not a DBA. I have never once had a DBA...
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 23, 2013 at 7:00 am
Koen Verbeeck (10/23/2013)
Even hardcore DBAs like Gail, Jeff and others have gaps in their knowledge.
I am not a DBA. I have never once had a DBA job. I'm 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
October 23, 2013 at 6:35 am
Make sure that SQL is stopped for the entire duration (or if it's just one database out of many, that the database is offline)
If you have a tool that claims...
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 23, 2013 at 6:09 am
Does the account that SQL Server runs under have permissions to that share?
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 22, 2013 at 4:55 pm
abhishekreddy62 (10/22/2013)
lets suppose an example... If for particular index we have logical fragmentation as 10%and the range_scan_count as 400000..will that index need to re-indexed?
Logical fragmentation looks low so...
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 22, 2013 at 4:53 pm
There isn't a relationship.
range_scan_count
Cumulative count of range and table scans started on the index or heap.
So that's the number of range scans executed against that index since SQL Server was...
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 22, 2013 at 4:34 pm
madhu-686862 (10/22/2013)
So total 4 GB is used for both the instances out of 16 GB. So where is the rest of memory 12GB going?
That's what you're going to have 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
October 22, 2013 at 4:29 pm
Yup, so the server has less than 200 MB of available memory, so there's no free memory for SQL to allocate. Hence there's no way it could allocate more memory....
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 22, 2013 at 2:11 pm
Viewing 15 posts - 11,206 through 11,220 (of 49,552 total)