Viewing 15 posts - 24,226 through 24,240 (of 49,552 total)
Depends if you have the concurrency set up correctly. I could see this happening, if the SQL code that picks up the next to process isn't careful about isolation and...
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
August 11, 2011 at 11:40 am
If SQL's max memory is set to 4GB then the buffer pool cannot use more than 4GB memory. SQL does take memory outside of the buffer pool for things like...
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
August 11, 2011 at 10:34 am
See the link above the forum name 'Control Panel'? Go there. In the 'Your profile' section is the option 'Edit Signature'
The edit box is a little broken, it only shows...
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
August 11, 2011 at 9:57 am
You do NOT need AWE on a 64 bit SQL. The setting is completely ignored.
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
August 11, 2011 at 9:17 am
There won't be a repair (this is irreparable). The content DB might be re-creatable, but that would mean losing all the contents of the sharepoint site (but there may be...
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
August 11, 2011 at 9:10 am
You'd need to bring the DB online to get information on the active portions of the transaction log.
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
August 11, 2011 at 8:48 am
Restore from backup or recreate the database from scratch, there's no other solution for this. The system tables are corrupt, this database is not repairable.
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
August 11, 2011 at 8:46 am
Doubt it's the insert portions of the queries. Probably mostly caused by these:
where cast(left(ph.CAPRIMDATE,6) as int) between @start_dt and @end_dt
where cast(left(convert(varchar(8),r.filled,112),6) as int) between...
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
August 11, 2011 at 8:11 am
It's not SQL. SQL has just under 4GB allocated.
Check perfmon, the process counters, working set for each running process on the server. That should help you turn up the culprit.
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
August 11, 2011 at 8:04 am
Stefan Krzywicki (8/11/2011)
I'm hoping Gail replies to this one with the same response she had to Brandie's two. It is a good stock answer for this kind of question.
Nah, I...
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
August 11, 2011 at 7:34 am
the sqlist (8/11/2011)
I will have to retract that. You actually can create indexes with the same name but on distinct tables.No issues with temp tables indexes.
Index names have to be...
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
August 11, 2011 at 7:32 am
archanab (8/11/2011)
I have to design a data base for a sales distribution system. The system has to maintain large number of parts ,customers and orders information etc.....
Hire someone.
Seriously. If you...
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
August 11, 2011 at 6:09 am
kumar.sachu08 (8/11/2011)
I need help to planning for create best database architecture in sql 2008.
<snip>
Also suggest me server configuration on which we will put such type of database.
Note : 3000 customers...
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
August 11, 2011 at 6:08 am
That error means that the connection was closed either by SQL or due to a server restart or something similar.
Run this on the DB and post the results.
DBCC CHECKDB...
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
August 11, 2011 at 6:07 am
Suresh B. (8/11/2011)
Oracle_91 (8/11/2011)
I was expecting the CKPT to do that for me. I 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
August 11, 2011 at 6:04 am
Viewing 15 posts - 24,226 through 24,240 (of 49,552 total)