Viewing 15 posts - 16 through 30 (of 35 total)
SELECT TOP 100
[Database_Name] = db_name(st.dbid),
[Object_Name] = object_name(st.objectid),
...
June 15, 2011 at 8:34 am
Have you restored the database where the mapping is missing from another environment? If yes you need to fix the users.
EXEC sp_change_users_login 'update_one', 'username', 'username'
June 15, 2011 at 6:24 am
If you have already identified the procedures then that was your starting point. Now determine how many times the SPs are running and for how long. From that statistics, determine...
June 15, 2011 at 6:05 am
Just do a search on the data file name in the SQL box and if it's not there in the box, then you have no other option.. go for a...
June 15, 2011 at 5:31 am
give it a try to see the correct usage of the table.
USE <DBName>
GO
DBCC UPDATEUSAGE (<DBName>,"SchemaName.TableName");
GO
and then run sp_spaceused
June 13, 2011 at 11:29 pm
What looks to me is yes, you need more memory. The target allocations tend to show more than the current allocation when SQL needs more memory.
Please monitor these perfmon counters...
June 13, 2011 at 11:24 pm
Index maintenance (reorg/rebuild/update stats) same for all the three instances?
June 10, 2011 at 12:01 am
Hmm, strange.. one box has SQL SP3 and that's taking a longer time.. RTM is faster.. Can you check in another SP3 box to prove the point?
June 9, 2011 at 11:33 pm
What is worrying me is "7054 severity 16 level 1 on spids 12s and 16s". SPID 12 and 16 are for SQL System processes.. What is the error description?
What is...
June 9, 2011 at 1:01 pm
Please post actual execution plans in the three servers. I believe the sql version, structure of table, database settings and patch level are same.
June 9, 2011 at 12:42 pm
You have to approach towards any performance issue systematically. First of all you need to ensure that it's a wait at SQL end, eliminating the waits at front end or...
June 7, 2011 at 5:09 am
I 'wd worry about a possible memory pressure if Target Server memory is more than Total Server memory, Page life expectancy is less than say 200 and buffer cache hit...
June 6, 2011 at 5:03 am
Please post output of DBCC MEMORYSTATUS. Also, what is the average pages/sec and target server memory?
Working set does not consider VAS and is not right to check memory pressure looking...
June 1, 2011 at 11:50 pm
You have already entered a house full of information. Most of the questions asked here are the problems faced or thinking ahead of a problem. Please browse through the posts...
June 1, 2011 at 11:06 pm
temp db by default has auto create and auto update statistics. When data volume changes in your temp table, SQL is likely to update the statistics after approx 10% data...
May 27, 2011 at 2:48 am
Viewing 15 posts - 16 through 30 (of 35 total)